You can create the links fast with this macro
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"coriolis" wrote in message ...
Hi!
Is there a function i can use to automatically generate a list of the
contents of a single cell from other worksheets? I have a file with template
project worksheets, and i have created "start" and "end" bookend sheets that
i can drag and click so that a roll-up summary is automatically created
summing certain cells on sheets that are included between the bookends, but i
also want to have the roll-up summary sheet list the name of each individual
project (ie create an automatic list of cell D6 from each worksheet that is
between my bookends). Is this possible?
--
thanks!!