Compiling Data from Multiple Stardardized Excel Files into ONE Excel Master File

This workbook should do it. It will need some customization from your part.

It will also only work with the file name you provided us with. You can improve it by having a variable bear the file name. You can google that, it should be fairly easy. You can also improve it by having it close the file after use, improve format or make it more efficient with a leaner code.

To enter another file, press the commandbutton again, the new set of data will be added in the next row. You can also run a batch of files, but that's more complicated.

Hope this helps.

Winch