Formulas being lost in second sheet after sort


If someone could help me with this please, 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?

Thanks for your help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!