Hi,

Wondering how to create a list of pre-existing tabs in a workbook. I have a
book that has appx 100 tabs and I want to create a list of those tabs on one
sheet.

Is there an easier way then doing this manually? The tab names keep changing
every month and I need to get a quick inventory of what's in the book.

Many Thanks,