I have a problem creating a sequence of an =INDIRECT formula.
Formula in C2:
=INDIRECT("'"&$C$1&"'!A1") in "Sheet 2"
C1: name of sheet1
Data in A1, A2 etc.
I want to create a sequence of the formula in C2, A1 must change to A2, A3 etc