Hello,

you can use the Indirect function for that. In C2 enter

=INDIRECT(A2&"!A1")

and copy down.

Note that Indirect() is volatile and will cause recalculation of your whole workbook when any cell is changed. This can lead to dramatic slowdown of a workbook. Indirect should be avoided.

If you present your wider context we can probably come up with a different approach that is more robust.

cheers, teylyn