Copy Filtered Data by selecting from a drop down list
 

Hi

I have a worksheet called "QRF" with data about a number of work processes.
This sheet will act as the database. For control of data I don't want people
to use this sheet at all so I want to create a second "reporting" sheet.

In the reporting sheet I want people to be able to select an individuals
name from a drop down list and a macro then filters and copies all rows
containing that individuals name and pastes to the "reporting" sheet. The
reporting sheet would need to clear/refresh each time the macro is run and on
closing the workbook. Can anyone help with this please. Thanks in
anticipation!