Coping data from one sheet to other related sheets

[Skidder]

Hi,
Trying to help wife with tenpin bowling admin. Each week a team of 3 individuals plays another team of 3 individuals. I have a results sheet that calcs which individuals won and which team one. All good but to save double entry I want to have Excel copy the individual results for each of the six individuals from the results sheet to their own individual sheet as a new line. The trick is once thats done I want to clear the results sheet and enter results for another 2 teams etc etc
Looked at a Pivot Table and Database techniques but unsure what approach to take...maybe VB script. Any help much appreciated.
Skidder