you need to get the tab name in a cell in the original sheet first
use the formula in for example cell B2
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
then on the other sheet you can refer to............... =sheet1!B2
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=479563