Filter, copy filtered data into another sheet, create a file of that sheet..

Hi there,

I have been searching the forum now for a while on filtering through VBA but the examples cited don't match what I am looking for, and I am not that good at VB to modify what I found to meet my requirements.

Here is what I need to do.

I have a list of items assigned to a person. There are a few persons in the list, each with different items belonging to them.

1. I would like to create a single sheet for each person, listing his items. If the sheets already exist (running the macro for the 2nd time, the contents should be erased and recreated)
2. I would like to have each person have his own excel FILE, so I can email it to them (e.g. peter.xls, maria.xls, frank.xls,...). Once again, if the excel file already exists, it can be deleted and replaced whenever the macro is run.

Attached please see an example.

NOTE: I don't want to manually autofilter in case anybody suggests that. This needs to be fully automated.

Thanks for your help, appreciate it!!
Titus