One List to Rule them all

[0rion]

Hi, I would like to make a 'master list' of all data in other lists.



Column A is a timestamp Macro watching B and C for data. Timestamp cell is locked.
Column A is "date/time", Column B is "Customer Name", Column C is "Customer number".
Sheet1 is City1, Sheet2 is City2. Sheet3 is State.

As data gets entered in B and C, the Timestamp, name, and number from either city is copied to the State sheet. Pasting of Values preferred, occasionally the customer number is blank. All data in this Master State List would naturally be sorted by the timestamp.

Essentially the State List sheet would be a changelog list of data entered in both cities, and additional cities if necessary (scalable).

Is this possible with formulas?
Thanks.