Try this with the sheet name in A1

=INDIRECT(A1&"!H2")

Mike

"Jake Sale" wrote:

Hello,

I know how to pull data from one worksheet to another i.e. ='2660'!$H$2.

But I want to replace the 2660 with a cell ref on the destination worksheet
i.e. ='A2'!$H$2 as this contains the source worksheet's name.

But this does not work.
An ideas how I can do this?