=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)))
Bookmarks