Today’s function is TAB_NAME; it returns the name of the worksheet tab in a cell

 

Today’s function is TAB_NAME; it returns the name of the worksheet tab in a cell.

LAMBDA(TEXTAFTER(CELL("filename",INDIRECT("A1")),"]",-1))