I have a range of data, which is a weekly sports picking competition at work.

Basically on the left it has the event, and along the top it has my work
colleagues names.

The sports picks are in the range and are in the form of validation lists.

What i would like to do is create an automated summary of who picked what at
the close of each week, which i can email out to the guys in the competiton -

i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g,
h, i, j and m

I have 8 events per week, with a number of options per event, thus it is not
easy or quick to just manually do it!

Any suggestions gratefully received!

Cheers!