Creating a List from a "Calendar-Style" worksheet

Hi,

I have a spreadsheet which has name IDs as a list in Column A with Row 1 [from B onwards] used to show the dates.

Name IDs will have a unique letter code under certain dates.

How can I make a list to show all the names for each date with content.

What I am looking to achieve is this:

I have multiple years worth of sheets to combine and the name ID list is over 200 long!

Any help would be much appreciated, thank you in advance!