Compiling Rider Scores

Hello,

I’m looking for some help. I want to compile rider scores for the Giro only (I know I can check total scores per rider). I’ve copied and pasted each set of scores from the stages page into tabs of an excel workbook but can’t think of an easy way to compile these onto one worksheet in a:

Name | Team | Stage 1 Score | Stage 2 Score | etc etc | Total

kind of format so I can see who scored how much and when.

I know it’s geeky, but I want to try and work out over the three weeks which would have been the best picks when and, for my purist team, who averages more points, sprinters, climbers or breakaways over the three weeks.

Any suggestions?