Gather data from different workbooks

[Joe9238]

Hey,
I have multiple files in multiple subfolders that have data in them that I would like placed into rows along in the workbook the macro is run from.

A couple points to note are:
-The files are all going to be xls files of some sort
-The folders and subfolders will contain various other files like .doc or .txt that should be skipped
-Some of the files may be corrupt or protected
-There are hundreds of files and many subfolders
-The files will contain a number of sheets, the one with the data in it is called 'QUOTE'
-Along the top I need the titles of the cells the data has come from and the data to be organised like this:

B7 l B8 l B11 l B13 l
----------------------
1 l 1 l 1 l 1 l
----------------------
2 l 2 l 2 l 2 l

Any help is appreciated
Thanks in advance

 

[SpillerBD]

-The files are all going to be xls files of some sort

What version of Excel are you using? 2003? If any files are XLS, you should update them to XLSX or XLSM(macro enabled).
PowerQuery can do most of what you're looking to do. (I'm not sure how the password is handled for protected books as I haven't done that yet.)
Corrupt files? Fix them or exclude them.

How consistent is the data placement in each worksheet?

Regardless of which method you proceed with, VBA or PowerQuery, you will probably have a long wait on execution. Both methods will end up waiting on the opening and closing of each file that meets your criteria.