If you're on 365 and able to upload an anonymized workbook (a few of the screen captures are small) sample, I can draw up the formula for you.
Edit: I've created a sample Demo:
Named items: city, data, uCity (unique list of cities)
Determine if a city is on tax sheet. If so, filter for the city and sum the results. Next, stack the city name next to the total.
filtered, FILTER(TAKE(Data, , -1), TAKE(Data, , 1) = v),
VSTACK(a, HSTACK(v, SUM(filtered)))
'Sheet level function