How to combine information from different excel files if the columns are identical

Hi,

I have ten different excel files, all with multiple sheets.

However, the different files have the same structure: The sheets have identical order and identical names, and the columns inside each sheets is identical to the ones in the "corresponding" sheet in the other files.

I was hoping to merge these files, such as the information from files 2-10 appeared as additional rows in file 1.

Is that possible, and, if so: How do I go about this?

Halvor