Data Templates - Excel macros needed.

We need to do a data conversion from one system to another. We have the templates that we need to populate, and the reports from our old system that contain the data. We need help creating a macro that will take the old systems reports and put it into the new systems template in the correct format.