Merging 2 excel files with different columns (user form to select files and column mapping needed)

Hi,

I need to merge two excel files into one with new column mapping - e.g. file one columns 1,3,5 to be located in columns 4,6,8 in output sheet.

As this will be done once a week, I also need to select files using a user form.

I have had a go so far and think I have come close, however it doesn't quite seem to work and I can't for the life of me figure out what's wrong with my VBA code.
The code is attached below:

Any help is MASSIVELY appreciated.

Thanks in advance,

Olivier

AttachmentSize
Code for merging files.txt7.19 KB