I think a pivot table is the way to go, but I see a few things I would to with your data.

1) Combine all sheets into one. I understand they are different in the sense of Admin, Misc, and Maint, but create a column with those designations which allows you to separate the data.

2) Remove the total rows. This can be done in a pivot table. Example, on the Admin tab row 3, remove it.

3) Fill in empty cells. Example, on the Admin tab, why leave A4 and A5 blank when they can both say Salaries