Help: Open all xlsx files in dir, copy data from cells and paste in 1 master xlsm

[dgibson]

So this may be a little complex and I am probably in WAY over my head. Here is what I am looking to do.

Lets say I have an archive of spreadsheets (xlsx format) saved in a directory (c:\test\). These spreadsheets have percentage rates in specific cells (eg: Sheet1, B2). This data is uniform across all archived files and wont change.

What I want to do is write a macro in a separate file that will open this "archive" directory, copy the percentage data that I define (eg: Sheet1, B2, C2, D2) and paste this data in the next empty row in the master document. This will allow me to quickly see and generate a stability report based on this information that I am pulling from these sources. I can then quickly see in columns if something is improving or getting worse.

I would like to note that I can piece together code pretty easily however when it comes to writing something from the ground up I am completely lost. So any and all help is greatly appreciated.

Thanks in advance guys / girls! This forum is a life saver!

[royUK]

See my code here. It will need some changing e;g the file extension