Populate list from Data Matrix

Dear All,

I hope you can help. I'm trying to get excel to generate a list of names (see attached spreadsheet - summary tab) from a matrix of data.

If anyone can help or point me in the right direction it would be greatly appreciated

Many thanks
Paul