How to use VBA procedures to generate a list of sheet names in an Excel workbook

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

source https://www.techrepublic.com/article/how-to-use-vba-procedures-to-generate-a-list-of-sheet-names-in-an-excel-workbook/#ftag=RSS56d97e7