Best formual or a pivot table?

Hi,

I am wondering if anyone could help me with which formula, or if a pivot table or link workbook would be the best. I have a table with debtors, some details and the staff who look after the customer. I want to show on seperate tabs, instead of filtering, who is looking after what account so I can see where they are up to. This is only an excerpt the worksheet has 900 customers. I want each sheet e.g. Mary (see attachment) to show what she is working on only. I feel vlookup wld leave blank lines which I do not want.

Any help would be greatly appreciated.

Please see spreadsheet attached.

Kind Regards
Lynda