Running totals based on multiple criteria

I have searched the forums but apparently Im searching for the wrong subject.

Here is what I am trying to do. Attached is a workbook I created to keep track of monthly, quarterly and yearly sales for my job.
I was told I needed to add, for each quarter and for the FY year, all the totals for each location.

Is it possible to create a formula, that when I input data in the location column, it will automatically total it on a corresponding line on the quarterly sheets and the FY sheet?

Any help would be GREATLY appreciated.

Try this on the 1stQuarter tab for October, and for "Mojave Viper".

=SUMIF(Oct!C:I,"M-Viper",Oct!I:I)

Then, just replace "Oct!" with the tab needed, and "M-Viper" with the Location notation in each tab.