Use Name of Tab in a Cell

I found something that would allow me to use the name of tab in a cell to make some of my work easier

=MID(CELL(“filename”,C1),FIND(“]”,CELL(“filename”,C1))+1,255)

Surprisingly, I found it on the Mircosoft answers site! https://answers.microsoft.com/en-us/msoffice/forum/all/making-cell-equal-tab-name/06486c8c-a1d9-4f2b-ba17-cf147161353c