Split Worksheet into Workbooks based on a column value

Hi ,

I want to split my worksheet data (DATA tab) into different workbooks based on a column value.
(1) Each unique value in Column 'A' will pick up all the data related to it from the DATA tab.
(2) Create a pivot of the the data picked up for this unique value in the next tab.
(3) Attached one sheet from a particular woorkbook ( May be Sheet1)
(4) Save it as a Separate workbook on a particular location.

Then move on to next unique value in Coulmn 'A' in DATA tab.

Attached is the sample workbook.

Thanks in advance for all your help.

regards,
Amar