Copy data from multiple workbook based on Column Name

[ChandruKumar]

Hi All,

I have around 100+ workbook (Source File) with different sheet name, I need to import data based on columns names. in the source file the columns were shuffled. Can anyone share the VB code to import data to a master template.

 

[arthurbr]

Perhaps RDBMerge, Excel Merge Add-in for Excel for Windows