Thank you for taking the time to respond. I am try to accomplish a simple task using VBA, but am not sure how the best approach...

The goal is to take an excel spreadsheet containing multiple tabs with unique names (Example: Alpha1, Beta2...) and to pull data from each tab name to a "Summary" tab all in the same file. Each time a new tab is created, I would like to run the program and it will update the "Summary" tab.

Any advice is greatly appreciated.


Thank you.