I have created a spreadsheet, which has a summary block at the top of the spreadsheet. It hyperlinks to the detailed breakdowns itemized in the summary. Then, each of the itemized blocks hyperlink back to the summary, to the next itemized block (if applicable) and to the last itemized block (if applicable).

Now, I'd like to add some lines to each itemized block, but the formulas that hyperlink don't auto-adjust to account for the added lines. Is there a way to get them to do precisely that?

I'm Excel for Mac 2011.