I assume you need to sort a range automatically, then use the following User defined function
or your refer to your file with changes made
Function SORTDATA(x As Range) As Variant
Dim n As Integer
n = x.Rows.Count
sortarray = x
Do
sortstop = True
For i = 1 To n - 1
If UCase(sortarray(i, 1)) > UCase(sortarray(i + 1, 1)) Then
sortstop = False
Temp = sortarray(i, 1)
sortarray(i, 1) = sortarray(i + 1, 1)
sortarray(i + 1, 1) = Temp
End If
Next i
Loop While Not (sortstop)
SORTDATA = sortarray
End Function