Try

=INDIRECT(A2&"!A1")

In article ,
Brisbane Rob
wrote:

Thanks Bob but all I get is an "error in formula" when I tried
=INDIRECT(A2&"!A1).
Help!