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