I would probably use a Pivot table; one for every sheet.
Then just select each town.

Ola

Details:
Put you 4 column as Row Items, and any column as Data field.
Deselect any subtotals and grand totals.
Mind the lenght of your pivot table and press ! every time the basetable
change.