Get data from source workbook and paste to destination in change format

Hello All,

I need a help i have two workbook in a folder i need to copy data from source workbook to destination while pasting the data it change the format of pasting like A1 header comes 1 time and similar for others . The workbook is attached.


Thanks
alam