WorksheetName and WorksheetsNo UDFs

Once you open the sheet and enable macros, you can use function:


To get total number of sheets in that workbook

And use function:


To get sheet name for first sheet, and


To get sheet name for second sheet and so on, I used the function Row()-5 in cell B6 to get the 1 and in cell B7 to get the 2