How do I create a summary worksheet that references data in other sheets?

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

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! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Auto Reference Worksheet Tab ID's in Formulas? 9
Can I create a 3-D reference from multiple workbooks 2
How to autofill the same cell reference across multiple worksheet. 1
Spreadsheet summary automatically referrences totals of worksheets 2
Relative worksheet reference for multiple worksheets in a workbook 5
Absolute Sheet Reference 3
Referencing Cells on Different Worksheets 2
Copying data to summary sheet 2

Back
Top