Hi mdeanda

You probably need to make use of the INDIRECT and ADDRESS functions. If
you enter the following in Column B in place of ="='"&A40&"'!"&"G4", it
should work.

=INDIRECT(ADDRESS(ROW(G4),COLUMN(G4),,,A40))

The ADDRESS function creates the address of the cell, and the INDIRECT
retrieves the value of the cell.

Regards
Andrew
excelthoughts.com