Split Data Into Multiple Workbook Based On Column value with exisitng sheet

Dear Experts

Help me on this task very help ful ever

I have workbook with set of data in RawData Sheet, and 2 Sheets of pivot table. I want split data of every rows of multiple unique values from column C:C with next 2 sheet... macro split data from column C:C and create new workbook with name of column value, with exisiting 2 pivot sheet.

e.g Symmetrix Computer Sys Pvt Ltd repeats 20 times in column C:C rawdata. once run macro those 20 values move new workbook with 2 pivot table sheets..

i have enclosed three sheets one input and 2 output sheet in name of value

Good to all