how do I merge two worksheets and save as individually
 

I know this is easy for someone that knows excel and macros. It is about
merging information from one worksheet to another.

I have two worksheets where one has a form like information and the other
contains the data. I need to insert three data fields into the form, €œsave
as€� the form (active worksheet) to the hard disk with the unique name from
the identifier, and repeat until end of data.

Form name is TRIO VEHICLE WORKSHEET and has the following structure with
cells C1, C7 and H7 to be filled with info from data sheet (row 2 first row
with info)
where C1 = &A2&, C7 = &N2& and H7 = &P2&

| A | B | C | D | E | F | G | H |
1 Vehicle# &A2& Requirement (current/new):
2
3 AL:
4 Actual/expected annual mileage:
5
6 Worksheet completed by: Date: 12/24/2006
7 Contact number: &N2& e-mail: &P2&
8

Data sheet is named VehiclesID and has the following structure

| A | N | O | P
|
VEHICLE_Id PHONE RATE USERID
10-14972 5533193
10-4183A 5533030 260.8
10-4243A 5533000 260.8
10-4260A 5533842 260.8
12-20376 5242481 230.4
41-47534 5539013

Please help!!!