List competitors per event e.g. to create a summary sheet.

Guys,

Nearly finished my latest project, but need your expert help once again!!!

I attach a workbook which has only 2 sheets. One is when I'm at now (Start), but I need to create a summary of competitors per event which I simply can't get right.

An example of the expected output is also in my workbook called Summary.

What I need to do is....

For each event, generate a list of participates from column H, L, P etc, and place the value only into the corresponding column on the summary sheet.

Hope you can help.

Thanks for looking.

Skyping.

P.S. I've removed all the code from the file as there's a lot of it and it doesn't really affect my request!!!

P.P.S. Potentially the amount of participants could go to B267 but no further.