referencing same cell in several worksheets

[coriolis]

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!!

[Ron de Bruin]

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


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


"coriolis" <[email protected]> wrote in message news:[email protected]...
> 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!!

[protonLeah]

• In the appropriate cell, type:
  =Sheet1!D6
  Just replace "Sheet1" with the names of your sheets, etc.
  
• Alternatively, on the sheet where you desire the list of project name, click in a cell, say D6, type "=", then go to the sheet with the project name and click the cell holding the name, and press TAB to accept.

___________________________
Ben