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" wrote in message
...
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!