Using Tab Name As Search Value - Issues using Cell("filename")

[AlInVegas2]

I have a list of records where the SearchName column is in alphabetical order. There are multiple records with the same name entered. I then have multiple tabs, one for each individual listed in the SearchName column. I use the following two formulas in each tab to get the rows for the first and last record for each individual. The issue is, when calculating the value on one tab, all the other tabs get updated to the same value. Is there a better command that won't change based on the users active cell location?

First Record =MATCH(RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))),SearchName,0)
Last Record =MATCH(RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))),SearchName,1)


EDIT:
I just updated the formulas using TextAfter(Cell("filename"),"]").... same result

First Record =MATCH(TEXTAFTER(CELL("filename"),"]"),SearchName,0)
Last Record =MATCH(TEXTAFTER(CELL("filename"),"]"),SearchName,1)

 

[RoryA]

Except in very specific circumstances, you should always include a cell reference when using CELL to anchor it to a specific sheet - i.e. use CELL("filename",A1) not just CELL("filename")

 

[AlInVegas2]

Solved my problem. Thanks RoryA