I have a user who has multiple workbooks, each which contains multiple worksheets. She wants a list of all her worksheet tabs, as a record of the contents of her workbooks (would result in a list of company vendors)
Is this possible? I have googled this without luck, which may mean the answer is “No.”