Use of the Contents of a cell as a worksheet name in a function

[tooMuchFun]

How does one use the contents of a cell to contain the name of a worksheet
and then use those contents in a formuala...

e.g.
A1 = separate worksheet name
A2 = contents of (separate worksheet name!A2)
A3 = contents of (separate worksheet name!A3)
etc. etc... ( like to use fill down from here)

Played with indirect for awhile but I am missing something...

 

[T. Valko]

Try this in A2:

=INDIRECT("'"&A$1&"'!A"&ROWS($1:2))

Copy down as needed

 

[tooMuchFun]

Thank you... works like a champ

Try this in A2:

=INDIRECT("'"&A$1&"'!A"&ROWS($1:2))

Copy down as needed

 

[T. Valko]

You're welcome. Thanks for the feedback!