software

Suppose my workbook has 10 worksheets in it. Each one similarly formatted
from a template.
I want to create a summary page that references all other worksheets.
For example:
10 worksheets that all have a Production Date in cell B15.
I want to create a summary page, that directly reflects the project name and
the production date.

I can't seem to hit upon the correct formula or function for the summary
page to grab the date in cell B15 of the other worksheets.

Thanks for any help!
Hi GB

=Sheet1!B15
=Sheet2!B15
.................
.............

This macro create the links for you
www.rondebruin.nl/summary.htm--
Regards Ron de Bruin
www.rondebruin.nlquot;GBquot; gt; wrote in message news:1140463358.502727@sj-nntpcache-5...
gt;
gt; Suppose my workbook has 10 worksheets in it. Each one similarly formatted from a template.
gt; I want to create a summary page that references all other worksheets.
gt; For example:
gt; 10 worksheets that all have a Production Date in cell B15.
gt; I want to create a summary page, that directly reflects the project name and the production date.
gt;
gt; I can't seem to hit upon the correct formula or function for the summary page to grab the date in cell B15 of the other
gt; worksheets.
gt;
gt; Thanks for any help!
gt;
gt;
Thanks Ron!

I tried this but it didn't work, then I tried renaming my sheet and it
worked.
Apparently, it doesn't like the fact that my Sheet2 name was
quot;686-Project1(3)quot;.
I think it was trying to do the math on the name of the sheet because it
kept prompting me for file names to update.
Once I renamed it to quot;Project1quot; it worked.

Now I have to go rename all of my worksheets! quot;Ron de Bruinquot; gt; wrote in message
...
gt; Hi GB
gt;
gt; =Sheet1!B15
gt; =Sheet2!B15
gt; ................
gt; ............
gt;
gt; This macro create the links for you
gt; www.rondebruin.nl/summary.htm
gt;
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;GBquot; gt; wrote in message
gt; news:1140463358.502727@sj-nntpcache-5...
gt;gt;
gt;gt; Suppose my workbook has 10 worksheets in it. Each one similarly
gt;gt; formatted from a template.
gt;gt; I want to create a summary page that references all other worksheets.
gt;gt; For example:
gt;gt; 10 worksheets that all have a Production Date in cell B15.
gt;gt; I want to create a summary page, that directly reflects the project name
gt;gt; and the production date.
gt;gt;
gt;gt; I can't seem to hit upon the correct formula or function for the summary
gt;gt; page to grab the date in cell B15 of the other worksheets.
gt;gt;
gt;gt; Thanks for any help!
gt;gt;
gt;gt;
gt;
gt;