Cell value based on hyperlink

[ChkLane]

So, not sure if I titled my question correctly but here is what I am trying to do.

I want cell D3 from sheet 1 to look for cell E3 from another sheet. However, I want it to look for what is in E3 on the sheet that I create a hyperlink to in cell A3 of sheet 1.

So basically, cell D3 in sheet 1 knows it wants to look at cell E3 but does not know which sheet to look at until I enter the hyperlink.

Hopefully I have explained it well enough for someone much smarter than me to figure it out.

Thanks!!

 

[FDibbins]

Again, Im happy to help