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


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=386078