Hi,
I have two workbooks with data in each worksheets. I want to copy and paste some specific data of each worksheet of one workbook to its corresponding worksheets of another workbook.

WorkbookA (has 3 worksheet tabs with data).
WorkbookB (has 4 worksheet tabs with data).

I want to copy and paste specific data:
WorkbookA - 001 Worksheet to WorkbookB - 001 Worksheet.
WorkbookA - 002 Worksheet to WorkbookB - 002 Worksheet.
WorkbookA - 003 Worksheet to WorkbookB - 003 Worksheet.
..and so on and so forth...

Data name/ Field Name for each workbooks that I want to copy from each worksheets:

Workbook Data/ field names: (should apply to all worksheets for each workbooks)
1. Field Name: "Title"(from Workbook A) copy the details to Field Name: "Title"(in Workbook B)
2. Field Name: "Preparation" (from Workbook A) copy the details to Field Name: "Description"(in Workbook B)
3. Field Name: "COLUMN 1" (from Workbook A) copy the details to Field Name: "COLUMN 1" (in Workbook B)
4. Field Name: "#" (from Workbook A) copy the details to Field Name: "#"(in Workbook B)
5. Field Name: "COLUMN 2" (from Workbook A) copy the details to Field Name: "COLUMN 2"(in Workbook B)
6. Field Name: "COLUMN 3" (from Workbook A) copy the details to Field Name: "COLUMN 3"(in Workbook B)
7. Field Name: "COLUMN 4" (from Workbook A) copy the details to Field Name: "COLUMN 4"(in Workbook B)

All sample worksheets are uploaded in these link:
WorkbookA: https://www.box.com/s/r7rrqjhumghcxnvvu3ju
WorkbookB: https://www.box.com/s/o5tdg9d0ea68zm3760n2

Here's the expected result I am expecting for WorkbookB after the data were being copied from WorkbookA:
Expected Result WorkbookB: https://www.box.com/s/p8s0gr1jdcpy5w9ethu8

I have approximately 500worksheets per Workbooks so I can't bear copying and pasting them manually.
Hope you can help me on this. Thanks a lot! Regards,