Listing Sheets in Workbook
There is an Excel file that teaches how to perform the Listing Sheets in Workbook operation.
Excel Spreadsheet for Listing Sheets in Workbook
This workbook demonstrates listing sheets in workbook using VBA macros on a 105-row data layout.
Hope it is useful.