I have a workbook with 10 sheets with data broken out by region in the US.
But, I'd like to take the data from those sheets and compile them on one
"master" sheet within the workbook, that would have cell references to the
data in each region's sheet. So the master sheet is for viewing only. All
editing of data is in the individual region sheets.

Here's my question(s):
- Is there code that can lookup cells from an individual sheet and place
them on the master as a reference?

- Can it be done with a named range of cells from the region sheet?

Sorry, I'm still a novice at VBA, and trying to figure it out, but have no
idea how to tackle this.

Thanks in advance.
Brad