On each individual players worksheet, beginning in C7 you'll see =IF(D7='Week 4'!D7,'Week 4'!C7,0).
Now on the Week 4 worksheet you pick the winner in D7 with the points in C7.
If it's you entering all the data, then I'm guessing the bold is applied by you?
If you group all the worksheets you can apply all these changes at once.
|