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
Sheet Field
(A1)TIK1 =A1!G4
(A2)TIK2 =A2!G4
(A3)TIK3 =A3!G4