Keep Tally Of Team Scores

I need to create a sheet probably involving macros where I enter a numerical value into a cell (say B5) I want the sheet to assign a score to the value I enter and then add the score it generates to a table of values. Once ths is done I need it to automatically clear the original value I entered ready for me to enter a new value - rinse repeat..

e.g.

into B5 I enter 15 - on the right in the results table there are headings v w x y and z

say 15 scores one point for w and one point for z I want the sheet to add 0 to the totals under v,x & y and add 1 to the totals under w and z.

Then I want the sheet to clear cell B5 so I can enter a new value without manually deleting the previous entry.

If I can also copy the value I enter into a "history" which simply lists all the values I enter as I go along so much thebetter.