How can I link Excel cells when I am constanly adding and removing cells?

I am attempting to cost out food products sold by our culinary program and have tried to link cells from one workbook to another but encounter problems when I add or remove products from my inventory lists. When the inventory cell is shifted up or down it changes the price on my recipe workbooks which has required me to go back and manually change all the formulas to link the new cells. I’m wondering if there is an easier way to do this? I would like to be able to add and subtract new products without having to go back to my 10 or so recipe workbooks and change every single ingredient price.