Filter, Create folder and workbooks

Hi Guys,

I am pretty new to this forum and am looking for an automated workbook with the below requirements.

Have to create separate folder for each Owner name (Based on column 'D')

1. Filter the data for each owner and create a new workbook for particular owner and save the data in respective folders.
File name formate for the owner:- 'Base file name - Owner name' (eg; Data - A.xls)

2. Filter data for each owner and filter again for the status (Multi filter) and create new workbook for each status and save the data.
File name formate for the Status:- 'Base file name - Owner name - Status' (eg; Data - A - 1.xls)

And another requirement is the data format should be same as the base file.

Requesting your help with a vba program to automate this.

Many thanks
Regards,