Creating New workbook for each name defined in Columns and merger all the Excel files list below in each row

[Mahul]

Hi All,

Currently im looking for help on the below requirement..

I want to create new workbook based on the names defined in each column (C7 to C20).. also there are files listed below in each column (they are existing file..) Saved in a defined path., and save the newbook with merged files into different location (the destination for saving files will vary) hence Cell a cell containing the Saving destination as well..

Just to keep it brief

1. New workbook need to be created based on the names in columns defined.
2. Merging Existing Excel file into the new workbook defined in the cell
3. Saving the New workbook with all the merge data to the defined location in that column..

Below is the file format and for better understanding


[TABLE="width: 694"]
<tbody>[TR]
[TD] [TABLE="width: 623"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]From Location[/TD]
[TD][/TD]
[TD]C:\Users\Mahul\Desktop\Apple[/TD]
[TD]C:\Users\Mahul\Desktop\Apple[/TD]
[/TR]
[TR]
[TD]To Location[/TD]
[TD][/TD]
[TD]C:\Users\Mahul\Desktop\Day[/TD]
[TD]C:\Users\Mahul\Desktop\Month[/TD]
[/TR]
[TR]
[TD]Merge File name[/TD]
[TD][/TD]
[TD]2015Summary - Day 1[/TD]
[TD]2015Summary - Day 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]ACB1234.xls[/TD]
[TD]DFG1588.Xls[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]DEF2354.xls[/TD]
[TD]RTG4789.xls[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]