I have an Excel workbook with a number of sheets within it - the first sheet
is a summary of the data contained in the subsequent sheets and contains
hyperlinks to cell references in each of those sheets. My problem is that
when I ad a row to one of the detail sheets, the hyperlink in the summary
sheet doesn't automatically update itself to reference the new cell address.
Is there any way that I can do this?