=INDIRECT(cellabove&"!A1")

worked for me.

--

Vasant

"Rob Hick" wrote in message
oups.com...
thanks for the tip Peo, but it doesn't seem to have worked. All the
names of the worksheets are single words (no spaces) so it shouldn't
matter whether I have quotes or not (if I've understood you correctly)