VBA help in creating a consolidation spread sheet, for multiple files in one folder

[bakerman]

Since it would be too timeconsuming to open 100 files (and growing) i'd suggest you use a ADO-connection to retrieve the data from the closed workbooks.