Counting multiple items with multiple criteria from multiple sheets?

I'm sure there must be an easier way of doing this, but my knowledge is limited, so I thought I'd throw it up for you guys.

Raw data is captured every month, for all incidents and requests between 8 sites. Currently, I'm using a sheet for each month.

I need to report the incidents and requests across these 8 sites individually, showing a monthly summary of ticket statuses (see summary sheets).

I'm currently using SUMPRODUCT to populate an individual sheet for each site, but the entire spreadsheet is taking ages to update and has become unbearable.

Please could someone tell me if there's an easier way?

(I'm also using INDIRECT to help save changing the formulas for each month)

Many thanks in advanced for anyone mad enough to look at this,
Dave.

Don't select the whole column, ie F:F D:D
Put some row numbers in.

Each time I load your example file Excel crashes.

Indirect is making the performance worse, try the below to avoid Indirect usage.

Don't keep separate sheets for each months data.
Just merge all months data in a single sheet and assign a column for mentioning Month.
Now you don't need Indirect you can simply use other formula's to match the conditions or Use pivot table and make selections.

See the attached excel for Pivot Solution