Sharing Data Between Worksheets

[spartikus]

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?

 

[CBrausa]

Check your cell range. In your formula if your range is A1:Z196 but
your information is in row 197 it won't pick it up.

 

[spartikus]

I understand that, however, I want it update cells if I add them because
when doing a bid I am always adding or deleting products from it and I
want the other worksheet to update. I am guessing what I need to do is
some kind of Visual Basic Programing to accomplish this but I would like
to find a way so that I don't have to. Any other suggestions?