Returning a count on matching IDs, under a specific condition

[imnotblackimoj]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1
[/TD]
[TD]Sheet 2[/TD]
[TD]Sheet 3[/TD]
[TD]Sheet 4[/TD]
[TD]Sheet 5[/TD]
[TD]Sheet 6, Column 1[/TD]
[TD]Sheet 6, Column 2[/TD]
[/TR]
[TR]
[TD]Summary[/TD]
[TD]Los Angeles[/TD]
[TD]San Francisco[/TD]
[TD]Bakersfield[/TD]
[TD]San Diego[/TD]
[TD]All California Census Tracts[/TD]
[TD]Do they have good tacos?[/TD]
[/TR]
[TR]
[TD]Los Angeles[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5432[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]San Francisco[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9876[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]Bakersfield[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1234[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]San Diego[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5678[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]

I attempted to simplify the concept by providing a basic example of what I'm trying to do.

The above columns (A-F) are separate sheets in a workbook.

I want to paste unique values (census tracts) for each city in its respective sheet (B-D). I then would like those inputs to match census tracts numbers in Sheet 6, column 1, and return the count of "Y" in Sheet 6, Column 2 to Sheet 1, under the respective city name.


For example, if I were to drop all census tracts that fall within Bakersfield in its sheet, I'd like to be able to refer to my summary sheet to determine the number (count) of "good tacos/census tracts"

Horrible example, hopefully you get the concept.


EDIT:
Also,

COUNTIF as an intermediate step won't work because I'm going to replicate this workbook, and the number of variables/geographies will vary. For example, this example only uses a handful of cities, other sheets I create will have 50+ variables.