Excel macro to move data from one spread-sheet to another.

Description of excel work: Please find attached one spread-sheet called “Initial” – this spread-sheet contains our initial data, which we would like transferred to a new spread-sheet in the same format as the other attached spreadsheet “Final Res”.
Please also find attached one spread-sheet called “Final Res” – this spread-sheet contains our anticipated final result.
Please also find attached one document called “Data Mappings” – this contains a table showing the data mappings for transferring cells in the initial spread-sheet to a target spreadsheet.
We need a macro that will automatically transfer the information from “Initial” to another spread-sheet with the same formatting as “Final Res”, using the “Data Mappings” document provided. This is only a sample of the data that we’re using – our actual document contains 1400 pages, so this macro will need to be able to cater for hundreds of thousands of records.
We also require that this macro will only need to be run once to map all of the data.
Extra notes: