Need vba to split data into multiple worksheets based on column of P & save wb with FY 16

Dear experts

I have sample data in which i require on column P:P values get split as new workbook in target folder as xlsb.

like values get unique TE001,TE002,TE003...etc. i want split every individual work with name of sheet(FY 16) and workbook save FY 16 TE001 Rpt,FY 16 TE002 Rpt....etc

find the attachment

Hi sir I getting error @path i want save files to this path C:\Users\Admin\Desktop\VBA\F\New folder

Thanks Expert Amazing Piece of work!!Solved