Excel: Mapping fields 2 specifc layout

I need some advice on some resources. I have 2 excel documents one is a raw file with a lot of data, the other is a company formatted document. I need to create a mapping between the two documents. The dynamic part of this is the raw data is never the same in respects to the number of rows; however the columns are always the same.

Anyone have any suggestions on how I should approach this?

Thanks in advance