I inherited a workbook with 50-odd tabs. I need to create a summary sheet that will reference each tab in Col A of my summary worksheet. Can I do that without having to type in each tab name manually.
If it will help I can put the names in Row 1 and transpose when I'm done.
Thanks,
Dave ....
Bookmarks