I am using Office for Mac 2011

I have 80 restaurants that I manage the maintenance budget. I have a single tab for each restaurant that has expenses for each month and the quarter sub-total and the Y-T-D total expenses per restaurant.

I have been requested to create a Summary Page that has all 80 restaurants listed with the quarterly expenses and the total spent to date per restaurant so they do not have to go through and look at each individual page.

I know how to take the total from one tab and insert it on the summary page but looking for a shortcut so I do not have to do this to 900 different cells on the summary page. The data is in the same location on every tab as they were created from a template I made so I am thinking there is a simple way to do this I am not aware of.

Any help would be appreciated. Here is a sample look of what I have:

On the individual restaurant page:

Description of Expense Jan Feb Mar Q1 Apr May Jun Q2......etc

There may be 40-50 items listed for each restaurant and the expense is inserted in the month it occurred



On the Summary Page they want it to look like this:

Restaurant Q1 Q2 Q3 Q4 Total YTD

Burger Joint1
Burger Joint2
Burger Joint3