Brad,

If you have each region sheet in exactly the same format, you wouldn't need
VBA. On the summary sheet just refer to the region sheets, like this

='Pacific Northwest'!A1

and other cells.

--

HTH

RP
(remove nothere from the email address if mailing direct)


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