I want to create a list of all the worksheets in one workbook, "table of
contents". The table of contents for a report - basically listing all
departments (that's what the tabs are)

I know there is an indexing function, but I don't know how to use it for
indexing or listing worksheets.