It might be easier once you have your master sheet with all the
fixtures on it to just copy this sheet to make a "master predictions
sheet" which once fully set up can then be copied for each of your
participants. That way, if the first game's result is in cell D6, for
example, it will be in the same cell on all the other sheets, so it
will make it easier to construct formulae to compare the prediction
with the actual.

You could print this out to act as a Data Capture document for your
friends to fill in - it will make it easier to record each player's
predictions.

You only need to enter the score for both teams - the result can be
worked out from this and return codes such as H, A or D for Home win
(first team listed being the home team), Away win or Draw. The same
formula can be included in the predictions sheets (based on the
predicted score), so again this is easier to compare with the actual
result - your players would thus put in a predicted score only.

I think you will need one summary sheet which will list all the
participants and report on the (game) scores from their individual
sheet.

Quite a nice little project - hope these comments help.

Pete