This can be done. I guess from your post that there will be several folders from which you would need to consolidate the data, right?
Why dont you attach a sample file containing some dummy data in the same format as your original data. Also, on a separate sheet in the same workbook provide a list of the folders (atleast a few) so that i can create a suitable code for you. This will save a lot of time in explaining how the code works once its done and also save time in specifying the requirements for the code to work.