link to sheets

[Guest]

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?

 

[Ron de Bruin]

Try the code example on this page to get a new sheet with links when you want it
http://www.rondebruin.nl/summary.htm

 

[Guest]

Ron, this worked out fine. Thanks for the tip

Try the code example on this page to get a new sheet with links when you want it
http://www.rondebruin.nl/summary.htm