Auto-sort macros for newly added fields.

Greetings,

Is there a macros that means I do not have to keep sorting a range from A-Z manually?

I have a table with fields including Contact, Address, Email etc... My worksheet has a userform so a new Contact can be added. I would now like that new Contact to be added into the table in the correct alphabetical order. Is there a way of doing this automatically?

Is it a table or just data in a sheet?