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!