Add files in Excel

Hi!

I am quite new to Excel, and need help.

I am currently collecting data with an online program, which generates data in separate files for each participant. Not all output is of interest for me either.

How do I combine the multiple files into one new file? With a script? And can I choose specifically which rows of data to extract from the orginial files into the new file?

Help is much appreciated, and the more you break it down for me the better.

Kindest,

Mikaela