professor-excel.com
How to Get the Name of an Excel Worksheet
There are two ways of getting the sheet name in Excel and showing it in a cell or simply using it within formulas: With an Excel formula or a VBA macro.