I've been trying to solve this problem forever. Is there a formula or macro to find all the names of worksheets in an Excel file?
I know how to get sheet names on the page itself.
But not unto other pages. So I want to pull all the sheet names unto a Summary page.
Also if possible, the solution should be able to adjust for additions to new tabs.
Thanks for your help, I really appreciate it.