Generating random cells from a list

Hi, I'm a newbie to VBA

I have a list of participants who've each had 0 to 5 attempts at an event and a list of scores obtained.
Suppose a participant has had 2 attempts, I have to randomly choose 2 scores from the list given.
If one has had 3 attempts, I have to randomly choose 3 scores and so on.

How do I proceed ? Thanks