Data between tabs

conor - Apr 2, 2015 at 11:44 AM

I have a number of sheets for pricing a product we produce, so in sheet 1 I place the purchase price of all the items we buy then sheet 2 I select the items in sheet 1 I want to include in the pricing of a certain product.
When I copy across the data it is fine but then if I alter sheet 1 by inserting new lines, doing a data sort by a different column it messes up my pricing in sheet 2 as it does not change the formula along with the changes made to sheet 1.

Any ideas on this?