|Something has to tell Excel to sort the data after an entry is made, so it's either got to be the user or a macro.|
Excel does provide "event driven" macros, so you wouldn't have to manually call the macro, which makes it kind of automatic.
For example, the following code will automatically sort Column A as soon as an entry is made in that columns:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Columns("A:A").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.