Hi. Was wondering if anyone knew if there was an easier way to consolidate a large number of spreadsheets into one without doing a load of vlookups (due to them being large sheets and other people colleges adding new lines)?

For example are there any macros that can pick up a load of data from the other spreadsheets and past them into my consolidated spreadsheet without any hassle. Then perhaps have formulas to pick up the data from the consolidated workbook.