Need help creating custom sheets based on auto filter results

I am looking to run a macro on a workbook that is filtered and moved to new sheets based upon filter results. I have attached a dummy workbook with the columns that I am using. And the new sheet titles that I need. Thanks if anyone can help!Book2.xls

hi trow, welcome to Excelforum, please check attachment, press Run button