Merge and combine common fields selected from multiple Workbooks

Suppose a situation where you need to combine a number of files where not all files have the same number of columns (fields) ~ e.g some files have additional fields as per below.

Despite the inconsistency in the number of fields, the compilation is still possible as long as the combination is done using fields that exist in all files ~ the field names that are common.

A template MergeFile2 as per attached could achieve the needed data compilation based on these common fields.

E.G: Some common issues with source files being: 1) existence of blanks and 2) inconsistency in the number of fields

Screenshots of MergeFile2

Fill in the common fields as per below FIELDS column  >>>  Click on Combine Files

Key in the sheetname where the data resides

Select the files for compiling

Screenshot of final output

DOWNLOAD MERGEFILE2