Is there a way to combine multiple excel files into 1 file?

[anon123]

Hello,

We have about 400 different excel files that we want to combine into 1 file. They all have the same structure.

Is there an easier way to do this copy and pasting 400 times from each file into the 1?

[anon123]

Nevermind, problem solved. For posterity, found it here: [pcreview.co.uk...] .