VBA to Split Records For 3 set of Unique Values in column P:P as new workbook to path

Dear experts

I have master report which consolidated structured data i want split as three unique records depends upon state code in column P:P,copy to new workbook save file name as xlsb in target path.

there is 11 unique records in P:P like AZ,CA,FL,NY,NJ,NM,MS,NH,TX,GA,HI i want split wb as Report - AZ_CA_FL_MIS.xlsb,Report - NY_NJ_NM_MIS.xlsb,Report - MS_NH_TX_MIS.xlsb, atlast Report - GA_HI_MIS.xlsb becz there is 2 end file only so it get split only two values.



Please find the attachment Foxstreet is master file, rest of two file excepted result