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 ...
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/