Maybe

=indirect("'" & A1 & "'!" & "D2")

or maybe the suggestion at your other post????

mike wrote:

I think I am approaching this wrong way and their might be an easier way any
help is appreciated.

I am trying to have a cell return a value from an adjacent €œtab€� within the
same workbook.

EX:
Cell €œA1€� contains the title of another worksheet, within the same file
(workbook)
In cell €œB2€� I want it to return the value (number) located in cell €œD2€�
from the €œtab€� name defined in cell €œA1€� I tried this but for some reason
only get an error after entering it into the cell:
=ActiveCell.Range(A1).value2.€�D2€�
Is this correct?

--

Dave Peterson