Update Tables via new records from Master Table

[AirNewbie]

We have a master table to track all bookings made on our platform, There is then a table for each partner location we have, I would like to automate the updating of the individual locations tables when a booking is added to the master list. 

Example, Booking 123 is added to master booking list for New York Store, -> Finds table named New York Store -> Adds the new records details to this table

[TheTimeSavingCo]

Hmm, I think I would try:
1. Create an automation that'll trigger when a new record gets created
2. Add a conditional step that determines which location its in
3. Add an "Update Record" step that'll create a new record in the appropriate table and link it to the triggering record

And then in all the partner location tables I'd add lookup fields to display the data from the main record