Data mapping from one excel workbook to another excel workbook

Hi Friends,

I need to map data from one excel workbook to another excel workbook. I need to open the source workbook then need to create new workbook and some cells of data needs to be maped from source workbook to newly created workbook.

Source workbook has one sheet (Source)

newly created workbook also contains one work sheet (Dform)

Some cells of source sheet data needs to be mapped into Dform sheet.

The following is the Algorithm

Private Sub CommandButton1_Click()

GetSourceDirectory
Getsourceworkbook
Getsource worksheet

For i = 0 To NoOfDocs

Read source sheet
Getcells
DumpIntoTraget
Next
End Sub

All the cells under source sheet column from following table needs to be mapped to the cells under Dform sheet.

for example : sheets("Dform").range("AP11").value=sheets("source").range("b13").value

please find the attachement for mapping cells details


I need to map nearly 2000 source files into Dform files. Please kindly provide the macro or logic to complete this task.

Thanks & Regards
Ramesh