combined tabs from different files into one

[daveyc18]

ok, i got 12 different files and each file has a summary tab (and thus same format but different numberS)

basically what's the most efifcient way to bring all these summary tabs into one file (thus, this consolidated file will have 12 tabs)

i dont want to open all files and manually copy and paste (or use the move/copy function) each tab into the conslidated/master file

there must be an easier and faster wya to do this

 

[sandy666]

maybe try Power Query with From Folder feature, then Edit and then filter by Summary

for more info:

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

Import Multiple Files from a Folder with Power Query - Gorilla BI

In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a folder. It works as follows...

excelgorilla.com