I am trying to create a spreadsheet for doing bids at my job.  On one
worksheet I view things like quantity, description, and product cost as
well as the sale price, etc.  On another worksheet I have created an
invoice for the customer.  What I want is for the data on the first
worksheet to link and auto update the information and bascially build
the invoice with the data enter on the first worksheet.

I know how to link cells from one worksheet to the next and it will
update for me if I have all the cells formatted the same but if I
insert a new row to add a product it doesn't update to the second
worksheet.  Could someone give me some good advice on how best to build
this spreadsheet?