I have been asked to consolidate information from a lot of files. I have a folder with excel files, I need to extract one single tab (or worksheet) from all of them. can this be done?

my preference would be to automatically merge these tabs(or worksheets) into one; however, I am still fine to have them as separate files, then I can merge them.

What would I need to do during set up? do all the tabs need to be named the same?

example, I have 50 budget files, each budget has a tab that summarizes the data from other tabs. do the tabs all need to be named “summary?”

​I have been asked to consolidate information from a lot of files. I have a folder with excel files, I need to extract one single tab (or worksheet) from all of them. can this be done?my preference would be to automatically merge these tabs(or worksheets) into one; however, I am still fine to have them as separate files, then I can merge them.What would I need to do during set up? do all the tabs need to be named the same?example, I have 50 budget files, each budget has a tab that summarizes the data from other tabs. do the tabs all need to be named “summary?”  Read More

​