Excel code need to conditionally copy rows

Hi there,

I have a spreadsheet with many worksheets which are task lists for each of our clients (e.g. CTC). Each sheet has a 'who' column (starts in I10) where the initials of the person responsible for that task can be chosen from a drop down.

I would like to have a summary worksheet for each person which picks out the rows (tasks) that have their initials against it. (without deleting it from client task list).

For example I have a sheet for client CTC where 3 tasks (rows) belong to VO and another sheet for client ENT where 4 tasks (rows) belong to VO so the 'VO Summary' sheet will show 7 tasks (rows) (starts in A10).

hope this makes sense - if you need any further info let me know!

many thanks