Sheet Name Reference

[radlernyc]

Is there a way to have a reference to a sheet name. The formula would pull the sheet name from a list in column A. The problem is a macro is generating sheets with sheet name = to names in a list. The name will change, and therefore I cannot use static name in the lookup.

Sheet Field
(A1)TIK1 =A1!G4
(A2)TIK2 =A2!G4
(A3)TIK3 =A3!G4

 

[Barrie Davidson]

=INDIRECT("'"&A1&"'!G4")

Assumes the sheet name is in cell A1.

 

[cfree36]

if you are using a lookup formula... name your range.
If the range is named... when the sheet name changes so will the named range and your lookup will still work.

 

[radlernyc]

Thanks...