Macro Code To Copy Dates And Text To A New Worksheet

[Sabrina68]

Hi All

I joined the forum yesterday, the amount of information on here is amazing. Managed to solve a few problems and learn quite a bit. I am new to VBA and macros and in the very basic early stages.
I spend a lot of hours a week working on a file copying data into a report and I am wondering if it could be done as a Macro. I would like the Macro to do the following:

Copy certain data from the HSE Matrix to the Report worksheet.
The report needs to have the Course Name and Course Number and against each course list the names of the employees who are overdue that training or coming due that training.
I also need it to copy over any names that have a blank red cell against them (but only red) and ignore any cells that are white or grey even if they contain dates that meet the criteria.

I have already set up all the conditional formats on the sheet using the following formulas:
Green - Cell Value >than = TODAY()+60
Amber - Cell Value between =TODAY()+60 and TODAY()
Red - Cell Value <=TODAY()+30

Hopefully a sample sheet has attached
Thanks in advance to anyone who can help with this, have spent hours trying things and am getting in a muddle.