"SIMPLE MACRO

NEED HELP ON THIS
I HAVE ENCLOSED QUESTION EXCEL SHEET INPUT AND OUT PUT

I HAVE MULTIPLE UNIQUE VALUES IN A:A COLUMN IN TWO SHEET FROM INPUT SHEET I WANT SPLIT VALUES
FIRST SHEET NAME IS CCI
SECOND SHEET NAME IS ON SITE
IF A COLUMN HAVE VALUE Aegis Infoware Pvt. Ltd IN CCI :SHEET1
IF A COLUMN HAVE VALUE Aegis Infoware Pvt. Ltd IN ONSITE :SHEET2

MAKE OUPUT SHEET NAME AS AEGIS INFOWARE PVT THEN SHEET1 NAME IS CCI CONTAINS DATA ONLY ALL RANGE OF Aegis Infoware Pvt. Ltd SHEET1
IN SHEET 2 NAME IS ONSITE CONTAINS DATA ONLY ALL RANGE OF Aegis Infoware Pvt. Ltd FROM SHEET2

LIKE THAT MACRO SPLIT ALL UNIQUE VALUE
MAKE WORK BOOK NAME AS BELOW MENTIONED

Comnet Vision (INDIA) Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Symmetrix Computer Systems Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Coreiq Solution Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
JMS technologies -SHEET - 1 CCI-SHEET- 2 ONSITE
Digital System & Solutions -SHEET - 1 CCI-SHEET- 2 ONSITE
Digitech -SHEET - 1 CCI-SHEET- 2 ONSITE
Sheikh Enterprises -SHEET - 1 CCI-SHEET- 2 ONSITE
Upper Ganges Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
Gloria Services -SHEET - 1 CCI-SHEET- 2 ONSITE
Perfect Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
Computer Connection -SHEET - 1 CCI-SHEET- 2 ONSITE
NEXUS COMPUTERS -SHEET - 1 CCI-SHEET- 2 ONSITE
Sona Infotech Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Perfect Computer Network -SHEET - 1 CCI-SHEET- 2 ONSITE
Renaissance -SHEET - 1 CCI-SHEET- 2 ONSITE
Libra Technocorp -SHEET - 1 CCI-SHEET- 2 ONSITE
Emall(ecs) -SHEET - 1 CCI-SHEET- 2 ONSITE
Digitalcare Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Caddons Computer Services Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
TOUCHAUTOMATIONPVTLIMITED -SHEET - 1 CCI-SHEET- 2 ONSITE
M.J.Enterprises -SHEET - 1 CCI-SHEET- 2 ONSITE
Reliable Network Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Qbic Solutions -SHEET - 1 CCI-SHEET- 2 ONSITE
Aegis Infoware Pvt. Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Crystal Computer -SHEET - 1 CCI-SHEET- 2 ONSITE
Aim Enterprises -SHEET - 1 CCI-SHEET- 2 ONSITE
Creative Computers -SHEET - 1 CCI-SHEET- 2 ONSITE
Webx Technologies -SHEET - 1 CCI-SHEET- 2 ONSITE
Monarch Technologies -SHEET - 1 CCI-SHEET- 2 ONSITE
Supreme Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
E-line -SHEET - 1 CCI-SHEET- 2 ONSITE
Service Point -SHEET - 1 CCI-SHEET- 2 ONSITE
Blue Bell -SHEET - 1 CCI-SHEET- 2 ONSITE
Global It Net -SHEET - 1 CCI-SHEET- 2 ONSITE
Bluecom InfoTech Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Reliance Info Solutions -SHEET - 1 CCI-SHEET- 2 ONSITE
Super Computers -SHEET - 1 CCI-SHEET- 2 ONSITE
Cell World -SHEET - 1 CCI-SHEET- 2 ONSITE
Aprompt -SHEET - 1 CCI-SHEET- 2 ONSITE
Satyam -SHEET - 1 CCI-SHEET- 2 ONSITE
Maharaja Communications -SHEET - 1 CCI-SHEET- 2 ONSITE
Cyber Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
Computer World -SHEET - 1 CCI-SHEET- 2 ONSITE
DGT Systems Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Ultra Integrated Technology Services Pvt Ltd. -SHEET - 1 CCI-SHEET- 2 ONSITE
Binary Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
Baba Computers -SHEET - 1 CCI-SHEET- 2 ONSITE
Thakur Turnkey Services Pvt Ltd -SHEET - 1 CCI-SHEET- 2 ONSITE
Nestore Informatics -SHEET - 1 CCI-SHEET- 2 ONSITE
Baundia Infotech -SHEET - 1 CCI-SHEET- 2 ONSITE
Dynamic Systems -SHEET - 1 CCI-SHEET- 2 ONSITE
Dev Mohini Printers & Suppliers -SHEET - 1 CCI-SHEET- 2 ONSITE
Netcom Computers -SHEET - 1 CCI-SHEET- 2 ONSITE
Computer Gallary -SHEET - 1 CCI-SHEET- 2 ONSITE"