Help combining 5000 Excel Files into 1 single sheet!!!

[adamkpl]

Hi everyone - I've got around 5k individual excel files (single sheet)

id - 1
name - xyz
exec - mr. president
etc.
etc.
etc.

I'd like to take these files and combine them into a single sheet with columns

ID | Name
1 XYZ
2 ABC
5000 | done

Any advice - no experience with Macros I'm afraid Thanks in advance!

 

[jsotola]

you have not explained what data are you combining onto one worksheet?


your example almost indicates that you are capturing filenames, but it is not stated clearly.

 

[adamkpl]

you have not explained what data are you combining onto one worksheet?


your example almost indicates that you are capturing filenames, but it is not stated clearly.

The individual sheets are all simple 1-worksheet files with 2 columns (text and numbers / same order ) - which look similar to as i explained originally:

....1.............2
A "ID"... .......1
B "name"..... xyz
C
...
Z

Thanks!