Excel 2007 : Name Ranges Cell Referencing & Sorting

Greetings and thank you for your time. I am trying to resolve an issue using Name Ranges.

Sheet One is an Inventory Database that is organized by:
Item, Case, Unit, Invoice, Unit Cost, Tbs Cost, (etc)
and also calculates inventory values based on quantities that are entered by the user.

For each row of information I have applied a name range so that I can reference the data on Sheet 2 to calculate recipe costs based on this Inventory list from Sheet 1

Everything Works Great Until...

I filter the data on Sheet One. The Name Ranges are reference by the cells so when the data is sorted my recipes on sheet 2 are adjusted based on the newly sorted Sheet 1 and thus recipes become irrelevant.

Is there any way to maintain the cell reference even if its sorted? This would solve everything for me if I could get it to work. I am not trained in VBA

Thank you for your time!