Import content from separate Excel files to a single spreadsheet?

Hi everyone,

I've got several Excel files that need to be edited separately.
Once they have been edited, I need to paste the content of each file in a single separate Excel file.

Is there a way to retrieve the content from all the files in a folder, and merge it in a single file?

For example:
3 separate files > File1, File2, File3

Merged file, sheet1
File1
File2
File3

I'd really appreciate any help.