One additional note......

If I can find a way to search through columns "Q" through "AQ", look at row 1 and determine which column relates to a particular city then I could make a formula to go through each tab/worksheet and add up the totals for each incident type. Well, I would also need to publish all incident types as well so I guess this could also be a bit tricky..........once again, I defer to an expert where my skills are limited on Excel.