write a small excel macro

I have a number of excel workbooks (92 of them) that are produced by an automated report. I need to review their content, then update the background data that produces the reports. Then I re-generate the reports, review again, and once I am happy with them I publish the reports. To review them easily, I need to compile all the content of the individual workbooks into one workbook. All the workbooks produced are housed within one file folder. The new compiled workbook can be housed within the same folder.