I have a spread sheet that has 1 page (call it the import page) where we directly bring in from an internet link a list of item and prices. A second page in that spreadsheet references various prices and items from the first page.

Problem is, from time to time, we add a new object to the internet source of data. This results in a new row (or 2) added to the import page.

The result of which is all our formulas that referred to the data on the import page are no longer accurate, as the item that the formula was referring to has been "pushed down" to a lower row on the import page.

What is the most efficient way for us to structure this to avoid having to redo the links\formulas when the the import page changes?