The attached file will do it while giving flexibility on file names, number of files, and column specifications.

Have fun!

MyXL.xlsm