I'm working on a Financial Summary template and I have different tabs for
different Districts. I then have a tab that pulls different information from
each of these tabs to summarize each District's Financials. My problem is
that I need to make 21 of these for each of our Regions. When I change the
names of the tabs for each Region, the cell references do not work when data
is entered into the District tabs. All of the cells on the summary page stay
at 0. If I click on the cell and then push F2 and then enter, the data will
appear. I do not want to have to do this for every single cell as it will
take FOREVER!! Is there any way to fix this?