I have data with headers in one excel spreadsheet

A1 Item Code, A2 Item Description, A3 Department

I want to map the column data from A1 to a new worksheet template into
column A4

I want to create a macro that will automatically arrange the column info
from Worksheet 1, Column A1 into the new workbook under Column A4 under the
new correct headers.

Any ideas how to begin this process?

Thank you