Move data from one page in a workbook to another workbook.

[plair]

My boss, has said he wants a "automatic" thing....ok a macro to move data from one excel spread sheet/work book to another workbook. Both workbooks will be opened and in a viewing mode, but to make life easier instead of alot of copy and pasteing a macro would work better.

I have attached the two spreadsheets (the second one is a example)

Here is the data that needs captured:

Name under the office phone number (left side)
Company name (right side)
Contact (right side)
Phone (right side)
email (right side)
Date (in the middle) I know that the form might have to be changed
The firs listed part number - just as it is listed
then the total amount of the quote.

Ok, I think that is all.

Any help would be great.

Phillip