I have 6 sheets in a workbook with a bill of materials (BOM) on the first sheet. This is linked to the other 5. There are also links on the first sheet to the 2nd sheet. If I want to insert lines in the middle of the BOM I select all 6 tabs, highlight the rows, copy, insert copied cells. It updates all formulas properly except the links on the first sheet that refer to the second sheet. It treats those links like they're absolute references and repeats the formulas above the copied cells rather than adjusting the references properly. Any ideas?