how to make a particular cell assume the name of the worksheet

Originally Posted by AlanY

=cell("filename) in the sheet will give you the full address of the sheet, incl the sheet tab.

then you just need to extract the sheet tab as required

try this
=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1)))

=MID(CELL("filename",$A$1),FIND("]",CELL
("filename",$A$1))+1,LEN(CELL("filename",$A
$1))-FIND("]",CELL("filename",$A$1)))

This formular worked.

Btw, how did you come up with that lengthy formula