I have one summary sheet which contains a link to the same cell on multiple
other sheets (image a quotation with individual sheets per machine, and one
general summary pricing sheet).
At times, I need to change the sequence of my individual sheets to better
reflect the content.
Is there a way to automically update the summary sheet to reflect this
change of sequence in worksheets?