Why won't my hyperlinks update within the spreadsheet?

I have a spreadsheet that has several worksheets in it. On one worksheet I have a cross-section diagram with hyperlinks to another worksheet. The other worksheet shows the calculations that were used to determine the value of the clearance or interference of parts shown in the cross-section. The problem I'm having is that the worksheet where the calculations are being done is still undergoing some revisions and rows are being added and deleted to accomodate new calculations. When the new rows are added or deleted, the hyperlink from the cross-section does not follow the calculation on the other worksheet. Any ideas on how I can fix this?

Thanks in advance.

Regards,
Bob Hoffman