MasterFile.xlsx
MultipleFilesData.xlsx
Hi all,

I need help with appending data from several excel files with the same “data titles” into a single Excel MasterFile. I know there is lot of help/codes out there for simple merge/append, but this one has to extract relevant data and match column/row titles, (some Titles in some files may not be in the same order).

I want all this data to be brought in a single row in the new Excel MasterFile under appropriate Titles.
So data from each data file will be arranged under appropriate Column Titles without error.

Location where files saved are:
Master excel file is saved in Folder C:\Users\Nostro\Documents\MasterFile
Multiple excel files are saved in Folder C:\Users\Nostro\Documents\MultipleFiles

I am attaching the MasterFile (where data needs to be appended); and one sample file (I have more than 200) from where data needs to be extracted.
I would reapply appreciate help on vba coding or any other appropriate method.

Thanks.