My advice is, have data entered into single sheet, with a column with Data Validation List to select city. Your macro will set a timestamp for every entry.

When you need to display entries for certain city, you can:
a) Set the autofilter for entry table on this city;
b) Create a report sheet, where you can select the city using Data Validation List. Whenever the city is changed, an ODBC query reads data from entry sheet and returns the log for selected city as querytable on report sheet. (With latest versions of Excel, you have to create an Open Event for workbook, which overwrites the datasource for query - otherwise the query will stop to work. And you have to change te extension to *.xlsm);
c) Create a report sheet, where you can select the city using Data Validation List. Whenever the city is changed, the log for selected city is read from entry sheet using worksheet formulas. (This solution assumes, you have a lot of empty rows prepared in report sheets for future entries in entry sheet, and from time to tame you have to check, is there enough of prepared rows.)