VBA to loop through a folder and all sub folders opening excel files.

Hello,

I am looking to be able to compile a large chunk of data which is spread across hundreds of workbooks most of which only have a few lines.

They all have the same format using (A:D)

I would like to be able to specify a the root folder and have it loop through all the sub folders opening the excel files then copy ("A1:D" & LastRow) from that file onto a main compiled sheet.

I do not have a problem writing the code to bring the data into an array and dump it into the main workbook my only problem is looping through all of the subfolders and opening all of the excel sheets.

If anyone can help me with that part of the code that would be great.