Try this in A2:

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"tooMuchFun" wrote in message
...
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...