Consolidate Same Sheet from Multiple Workbooks

ndbeck

New Member
Joined
Jan 9, 2014
Messages
6
Hi,

I have a folder with files where I need one sheet from every file pasted into a master workbook. I have tried this with PowerQuery, but believe there are too many files for it to process.

My files are saved at the path: "C:\Users\user1\Desktop\Combine Files"

There are approx 100 files. All files have a tab called "A-Lead Sheet". I need to bring all the Lead Sheets into one workbook.

Thanks for the help.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Forum statistics

Threads
1,089,237
Messages
5,407,069
Members
403,121
Latest member
TimKromer

This Week's Hot Topics

Top