I am making a score sheet(sheet1) and handicap sheet(sheet2) for golf. On
sheet1 I want to add names to the list and automatically have the names and
score and handicap go in a to z order. So I need the name and handicap to
move up or down if a name goes in front or behind. Then on sheet2, I want
the names and score with handicap to update automatically when entered on
sheet1. The order on sheet2 needs to go from lowest score to highest score.
Here is an example

sheet1 score hc net
smith, bill 86 17 69
taylor, bill 96 26 70
williams, bill 76 12 64

then sheet2 would automaticallydo this
williams, bill 76 12 64
smith, bill 86 17 69
taylor, bill 96 26 70

I want sheet2 to base the order on the column with the score.

Thank you for any help, and I am new at this