Excel Question

I would have one list and then use a pivot table to display results by region.  Then you can see it by region or as a master list by removing the region as a filter.  Are you familiar with pivot tables?  Great power in a pivot.  PM me your email and I can send a file with an example.

I'm not 100% sure what you're trying to do, but it sounds like you're trying to display data that's on the first sheet on the next 7 sheets.  If that's the case then you just reference the sheet 1 cell on the other sheets with "=Sheet1!A1"

So on Sheet 1 you put all the data and then on all your subsequent sheets you use "Sheet1!A1" "=Sheet1!A2" "=Sheet1!A3" etc... and then when you add a new line to your master it will populate on all subsequent sheets.

Not sure what a pivot table is, need to look into it.

BUT, I found that I can group all 7 sheets, add a line item, and it will add it to every sheet. 

I guess a quick example of what I'm doing is District A has nuts, bolts and screws.  As does District B and C.  But when I get to D, it has widgets too.  Even though district A, B, and C don't have widgets, that line item needs to show up on their list but have a count of zero...

I just didn't want to have to go into each sheet and add a list item 7 different times.

When budget season comes up I have do this across several full workbooks and several spreadsheets within those workbooks and what tuwood is suggesting is what I do, also.  I' reference full sheets to an original and then write over what I need to.Just start with sheet 1 A1 and reference to it, then copy and paste that cell to the entire sheet.

Here is an example of a list with two different pivot table views.  One pivot table can provide both views simply by dragging and dropping the column names into either a column or row view.  The second pivot has the district as the filter.  That is a drop down box and you can view all districts or any combination of districts

ETA:  This took me about 3 minutes to throw together.  We use pivots for just about all the data we send out (Finance Department)  Slicers and pivots have made it much easier for the end user.

(Pivot.jpg)

yes...

Because on the front sheet, I need to grab totals from all the other sheets/"districts" and have a grand total.  I want to create a formulas that goes to the same cell on each sheet and totals them up.  But if I add a line item in district 7, that line item needs to show up in the summary and be included in every other district...

ANYWAY, I got something to work.  The only problem was I forgot to ungroup the sheets when I was editing the numbers in one district and it messed them up in every other sheet.  So as powerful and  helpfull as grouping sheets together is, it's just as dangerous if you don't ungroup them.