ceemo wrote:

I have various tabs example one named HGI

I want to have a formula that will look at cell B1 of a sheet i specify
in a cell

example report page cel A1 = HGI

I want cell A2 to look at cell B1 of the sheet that is named in A1

Hi ceemo

Try this in A2:

=INDIRECT(ADDRESS(1,2,,,A1))

Regards

Steve