Consolidate Same Sheet from Multiple Workbooks

[ndbeck]

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.

 

[sandy666]

but believe there are too many files for it to process.

why "too many" ?