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
http://www.rondebruin.nl/summary.htm


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


"GB" <(E-Mail Removed)> wrote in message news:1140463358.502727@sj-nntpcache-5...
>
> 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!
>
>

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
"686-Project1(3)".
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 "Project1" it worked.

Now I have to go rename all of my worksheets!


"Ron de Bruin" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi GB
>
> =Sheet1!B15
> =Sheet2!B15
> ................
> ............
>
> This macro create the links for you
> http://www.rondebruin.nl/summary.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "GB" <(E-Mail Removed)> wrote in message
> news:1140463358.502727@sj-nntpcache-5...
>>
>> 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!
>>
>>
>
>