Search results

You just need to set the reference to an absolute cell on the sheet. Thus cell("filename","$A$1") will alway only refer to the current sheet where it appears and =RIGHT(CELL("filename",$A$1),LEN(CELL("filename",$A$1))-FIND("]",CELL("filename",$A$1),1)) will always give the correct Tab reference.