Read data from one excel and write to other

Hello,

I am a newbie.

I am trying to find out if we can achieve the below scenario using macros.
We have 2 excels in our case.
Excel1 contains field values and data
Excel2 is empty and we need to write data from excel1.
Excel1 has different column names and Excel2 has different column names so we need to map columns in this two excel sheets and then insert data from Excel1 to Excel2.

Any help is highly appreciated.

Thanks.