Something like the following should work for the formala in cell A3,
although the workbook being referenced needs to be open.

=INDIRECT("'["&a1&"]sheet1'!$a$5")


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=480984