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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"rob" wrote in message ...
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?