Add new row and Loop range data from previous sheet - new to vba

I looking for the right code where Sheet2 will add a new row and populate the Column B cell of the new row with data from a range on Sheet1. I need this to occur every time I add new item to the range on Sheet1. So if I have:

Sheet1:
Column A (City)
Houston
Dallas
Column B (Region)
North
South
East

Sheet2:

Houston
North
South
East

Dallas
North
South
East

If I were to add West to Region on Sheet1, how could I have a row automatically added to Sheet2 for both Cities pulling the new Region? Thanks!

I dont know where you are trying to go with all of this, but I would probably use a pivot table linked to the original data.