how do i automatically sort a list
 

I have a range of indeterminate length consisting of 3 columns (name, team,
goals - it's a top-scorer list.)

What I want to do is have Excel automatically sort the full range based on
the Goals column whenever data is added to the list (ie new scorer entered)
or edited (ie existing scorer gets another goal.) to keep the list always in
order of most goals scored.

Anyone got any ideas?