Need assistance with my Basic Employee attendance Point Tracker

Hello,
I am new to Visual Studio and average with excel. I built this basic employee attendance point tracker using information from online tutorials. There is a few things I would like to do, but am struggling to figure out. FYI, the area's in gray will be hidden upon completion of my data entry form.

1st. I would like the data to automatically be alphabetized by employee name. I can only seem to get the whole column alphabetized. I need it from D14 down.
2nd. I need to figure out how to get my form to automatically detect an employees name, how many entry's and the points associated for those days and give the sum in the Total Points locations. Specifically when a new entry is saved.
3rd. Since my company keeps points for a year, I need my form to delete entries that exceed a year from the current date(today's date).

Any help is greatly appreciated. I am open to any criticisms or suggestions. Please bare my inexperience in mind. Special thanks to "Excel For Freelancers" for their web tutorials.

Thanks so much for your response Keebellah. Unfortunately I cant seem to get the Macro to action. Perhaps because its line d14 and down that needs the sorting, where as line d13 is supposed to be the highlighted or current entry selected. I tried changing the info, but I kept getting errors.

Runtime error. Object doesnt support rhis property or method.

ws.Sort.SortFields.Add2 Key:=Range("D13"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal