Migrating information into another sheet.
 

I want to migrated information on one spread sheet with column headers into
another with different column headers. For example sheet 1 has a column
labled Customer Address, Sheet 2 has a column labeled Primary Address. The
information on sheet 1 under Customer Address has to go into sheet 2 under
Primary addres. Each row on sheet 1 contains all the information for a
particular customer and all the other information on that row will have to go
through the same transfer. Is there a way to do this with a function or some
type of macro? The spreadsheet has hundreds of rows and roughly 45 columns of
information.

Thank You,
Richard