Forum Discussion
extracting a single worksheet from a file
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?"
1 Reply
michaelg1855 Look into Power Query (an add-in for Excel 2013 and fully integrated in Excel since 2016) to connect to all the files in the folder. Set it up correctly so that you only extract the "Summary" sheet of all the files. There are many tutorials on-line. For instance, this one:
https://exceloffthegrid.com/power-query-import-all-files-in-a-folder/
