Goal: To make an inventory workbook with sheets for each week. Example Jan 7, Jan 7 food cost, Jan 14, Jan 14 food cost, Jan 21, Jan 21 food cost, etc

Problem:I have formulas that calculate food costs. For example i have the recipe for salsa on the food cost sheet that pulls values for tomatoes, etc from the inventory sheet.

The problem arises when I add new items to the inventory sheet it messes up the formulas for the food cost because that cell reference no longer lines up.

I tried to use cell names instead for the formulas, but when i duplicate the inventory and food cost sheet for the next week, it ties that formula to all sheets and the food cost changes from week to week based on pricing.

Anyone have any ideas on how to make the formulas static based on the item?