Split Data Unique Value From 2 Sheet of A column and Move to 2 Sheet with Splited Values

I have Unique Data in column A:A in Two Sheet (Sheet1) as CCI & Sheet2 As ONSITE
I want split data Through End A:A Column From Sheet (CCI & ONSITE)

Out Put Result I want Splited Data move to new work with creation of names of Partner from column A:A
In output file also two sheet (CCI&ONSITE)

I uploaded sheet's (Input & Result Files)Please check if you can help me on this

Here Input File
Out File is Aegis Infoware Pvt.ltd.xls = Only contains (CCI&ONSITE) of Aegis Infoware Pvt.ltd partner's A:A column of INput
Next File is Aim Enterprises.xls = Only contains (CCI&ONSITE) of Aim Enterprises of A:A column of INput
like that
all uniques values get split and make sheet name of A:A column value.

I waiting for ur early reply dude's