merging of files without copy paste

[Sylvie]

How can I merge several files into one without copy/paste.

I have many differente files and I need them to be in one, how do I d
that and can I do that

 

[mudraker]

Excel does not have a built in function to merge workbooks