Update if each sheet is a new race.
Pivot Table should work, but relabel them time 1 and points 1/ time 2 and points 2, or you create a third page that sums the two together.
The third page consists of all individuals, this is perhaps more than 500?
Assuming your duplicate names are spelled the same.
Sheet1 is your first sheet
Sheet2 is your second sheet
Sheet3 is the combined Sheet1 and Sheet2
On the third sheet copy all the names from sheet1 and sheet2 paste in column A. Use the same titles and sort alphabetical and delete duplicates. Then in columns C, D, E, and F add these formulas and copy down to the last name.
The sumproduct will update the two spreadsheets whether they are open or closed. If you never need to use those other two you can hardcode the new spreadsheet.
Cell C3 Time 1
=SUMPRODUCT(--(TRIM(Sheet1!$A$1:$A$600)=TRIM(Sheet3!$A3)),--(Sheet1!$A$1:$A$600<>""),Sheet1!$C$1:$C$600)
Cell D Points 1
=SUMPRODUCT(--(TRIM(Sheet1!$A$1:$A$600)=TRIM(Sheet3!$A3)),--(Sheet1!$A$1:$A$600<>""),Sheet1!$D$1:$D$600)
Cell E Time 2
=SUMPRODUCT(--(TRIM(Sheet2!$A$1:$A$600)=TRIM(Sheet3!$A3)),--(Sheet2!$A$1:$A$600<>""),Sheet2!$C$1:$C$600)
Cell F Points 2
SUMPRODUCT(--(TRIM(Sheet2!$A$1:$A$600)=TRIM(Sheet3!$A3)),--(Sheet2!$A$1:$A$600<>""),Sheet2!$D$1:$D$600)
G3 adds d3+f3
