Automating Skills Matrix

Good People

I am trying to find the best option to automate a spreadsheet set up to track our employees skills.

I have applied conditional formatting to the sheet containg the master data to highlight those skills that are nearing (or have already) expired. This was working fine with a handful of employees but is becoming a handful as the workforce rapidly grows.

What I really need help with is how to pull the highlighted data across onto a "Report" sheet and have the ability to then generate an email for each employee to notify them of any skills needing attention. I would like to use a couple of buttons on the "Report" sheet to firstly run the report to pull the data with a second button to generate the emails for review prior to sending.

I have just started learning about programming in Excel but need to get this one sorted out fairly quickly. I have attached an example workbook to give an idea of my situation.

Any help is greatly appreciated!!

Anybody?!! Please help!