VBA help to match column header from different workbooks

[Wongjiaxin]

Hi all,
I am looking for some VBA code to help me with the problems, it would be great if one can help.

I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding header, and copy all the data in the column and paste into correct column on sheetname2. I would like to do this for all columns in sheetname2. and there might have some different headers names in sheetname2 but they actually have the same meaning as the headers in sheetname1, and i want to copy the data below those headers to corresponding headers in sheetname2 too.

Can anyone help me? Thank you.

 

[Wongjiaxin]

For different header, for example, the header in sheetname1 is contract no., but in sheetname2, the header is policy number. They have actuallysame meaning.