Can a Combobox in a Userform access multiple dynamic Tables

Hi all. I’m hoping I can get an answer to the following.

I would like to be able to update numerous tables with a UserForm. The particular Table would be selected from the UserForm via a drop down menu. All Tables are dynamic and on the same sheet. A sample file has been attached.

I have 2 command buttons on the ‘Buttons’ sheet, each opening a UserForm; One UserForm to enter new data into the Tables, the other to amend and, or delete existing data. (Depending on whether the later is possible).

In the ‘Add Suburb’ UserForm, there is a drop down menu (ComboBox?) to select the Table (City) in which the information is to go, and 2 text boxes for the information that is to be entered. The text boxes are called ‘Enter Suburb’ and ‘Enter Distance from GPO’.
The second UserForm ‘Edit/Delete Suburb’ is a little more complicated. There are 2 drop down menus (ComboBox?). The first is to select the Table (City) in which to edit and the second to select the ‘Suburb’ that needs editing or deleting. Like the first UserForm, this one also has 2 text boxes for the information that is to be entered or in this case amended.

If possible, the code should include sorting the table after the information has been entered. If this is not possible, then a separate ‘Sort’ button in the UserForm is required.

Note: The first Table named ‘Cities’ is definitive and does not get updated.

Any and all help would be greatly appreciated.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.