Hi everyone

I have several worksheets that represent yearly results (labelled 1995,
1996 etc...)

I would like a summary sheet that can pick out common competitors from
each sheet and add that years score to a 'rolling' total.

I had thought a Pivot table would do the job, but can't seem to make it
work.

One point to note is that within each sheet, there are an inconsistent
number of events - for example there might be 8 events in '95 and 9 in
'96 etc. Is that a problem for the pivot table?

Thanks for any suggestions
Neil