Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

Thank you!! Works like a charm!

If it's not too much trouble for you, could you please explain the code a little bit? I'd very much like to learn some new VBA stuff.

Thank you again!