Combine in a Excel document data from different excel files

I have several Excel files, all with the same structure but with different data (every project manager has his own spreadsheet). I need to combine all the data from these different files into one. Each sheet generally never has more than 100 rows of entries, and each document has 3 separate sheets, even though we may add one or two more in the next few months. This can be done with formulas, macros... it really doesn't matter as long as it works. The operation of combining data will need to be done once every week. You decide if you want to link the fields so it is always up to date, or if the execution of a macros should be done, as long as the user doesn't have to see code. Excel 2010