Sheet 1 contains two columns. Each column lists a hockey roster. Column A
is the "White" team. Column B is the "Dark" team. There are 22 spots
consisting of regulars and numerous substitutes. Any one player may appear
on "White or "Dark" from week to week. At the bottom of the rosters will
appear the score from a given nights game. On Sheet 2 is a list of all
players (regulars and all subs) in column A. Column B is "Wins". Column C
is "Losses". Column D is "Ties".

My question is: how do I format this so that once I enter the score at the
bottom of the rosters on Sheet 1, it records wins, losses and ties for each
paler on Sheet 2?