auto-sum non-numeric values across multiple tables

[OhHappyDay]

I am trying to auto-sum non-numeric values across multiple tables (tabs) and can do both of these separately, but need a combined formula.

My goal: I have demographic data on multiple different tabs that needs to be calculated onto just one tab. I want to be able to see a break down as such: from each tab, number of people who said "male", number of people who said "female", etc.

Is there a formula I can use, or do I have to use macros or something (which I am not very good at/comfortable with)?

On the attached spreadsheet, the "template" tab is the one in which the data will be pulled from and the "report tracking" tab is where I want the data to auto-sum.