Excel order/packing sheet

Hi this is my first post and i hope someome can help me .
I have a Excel workbook and on pg 1 i have an order form/price list. It has 500 cells approx which are the products, listed in column A. Pricing strcture runs B to G in the column with pricing and H is where you put in your order QTY and i gives you a sum Nett total of you order. Very basic, very simple.
I would like to add a packing list to the work book where as when you fill in you QTY number in column it transfarees the data in that whole cell to the pg2 in the woek book and i can save it and email to my office.

I hope some can help as im new to excel.

Thanks
Philip