Quotation calcultor

Hi,
I have 2 different quotation calculators and i want to be able to popular the values at the top of the calculator i.e, name, address, telephone num & email address and then let the calculator do the work. I hav this working perfectly with manual entry of data however i hav want to be able to create multiple quotations for approx 10 customers per day from a lookup list positioned in another worksheet, i was thinking if i cud get sumthin lik the way word mail merge works would b ideal i.e a set calculator format and the required fields populated and then another wuotation is made on the following page. Is there any way to do this as it is very time consuming as it currentky is

I have attached a rough non working copy of the calcualtor as the orginal contains sensitive information but basically as you can see calculator will need to take data from both sheet1 and sheet 3 to work. What I need it to do is calculate the amount going by the input which in the orginal copy it already does and then I need it to take the details in sheet 3 and create an individual quotation for each of the names/ vehicles listed in sheet 3. These details will vary from day to day so I need to be able to change the quoation on a daily basis, any ideas?