OK, so I have an Excel file that has about 15 sheets. The first is a parts
list and price list (two columns). Each of the remaining pages is a product,
with all the components listed, along with quantities and extended pricing.
The price column is made up of references such as ='Parts List'!B1 then B2,
B3, etc.

Now, I need to reformat the names of the parts on the first list, and then
realphabetize them. The problem is, this throws off the calculations on the
other 15 pages. For example, if B3 becomes B5, I need the formula to update
to say B5 instead of B3. Instead, it still says B3 and has the new price for
B3 listed.

Can anyone tell me how to fix this??