Auto-updating Price List via invoices

[Meatlesssugar]

Hey all,

I have been using a price book that uses a simple table EG Code, Name, Price for storing my product prices. I have it auto updating from another sheet in the same book so that as I update my recent invoices it updates the product automatically. another employee recently used it and rearranged the cells and broke the entire workbook.

Is there a better way to have this set out? I'm only using simple =Sheet2!C14 formulas so I understand its fickle nature.

Is there a better layout to use from the start? or just better formulas? open to any and all suggestions.

it would be nice if the table could be re-arranged without breaking the book

Thank you all