Copy Column name & row name if cell contains certain date [Closed]

Report
-
Hello,

I am trying to create a new worksheet based on the information in a previous worksheet. It is a training document and need it to pull out who needs what training.

Column A contains the name, Row 1 contains the training required. the cells are populated with the date the training expired. Some of these are blank.

I want for instance, if I choose "Jan", for the new worksheet to show each person and the training they require.

Can anyone assist?

Thanks