An Excel’s formula for getting sheet’s name…

…is as “simple” as:

=RIGHT(CELL("filename"); LEN(CELL("filename"))-FIND("]"; CELL("filename")))

Source: How to Get the Sheet Name in Excel? Easy Formula.