Opening folders inside of folders and pulling data from sheets present.

Hello Excel VBA Gurus!

I am working on an excel to compile data from separate locations. With the help of many other great minds I have reached this point.

Please Login or Register  to view this content.

At this point this file can pull various spreadsheets from within two folders that I specify in the first sheet, copy them, and then paste them into my spreadsheet side by side. My problem arises that in the final product it will need to look inside of folders within the one specified to find the spreadsheets. Each one of the folders within the specified folder has one spreadsheet and a bunch of unimportant folders.

Any thoughts?

Many Thanks

Any Ideas?