Returning a count on matching IDs, under a specific condition

[imnotblackimoj]

Sheet 1	Sheet 2	Sheet 3	Sheet 4	Sheet 5	Sheet 6, Column 1	Sheet 6, Column 2
Summary	Los Angeles	San Francisco	Bakersfield	San Diego	All California Census Tracts	Do they have good tacos?
Los Angeles					5432	Y
San Francisco					9876	N
Bakersfield					1234	N
San Diego					5678	Y

<tbody>
</tbody>

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.