Macro button to split data to multiple work book

Please someone help me on this request at the earliest possible.

I do have an Macro file with the code where when I paste my data in to Raw data sheet and click on the button it will ask to select the headers on the file and again I need to enter the column header where I need to split the data based on that column and data is getting segregated on the same file.

So I need the data based on below given requirements. Kindly help me on this.

When I click on the macro button, pop up should open to select the report from my local drive(the report will be in .xls or .xlsx or .csv format)
- Once I selected the report it should ask for the column header name to input.
- Once I input the column header name, the data needs to split in to multiple work books based on the unique cell value on the selected column.
- before saving the file the comma "," should be replaced with semicolon";" in any of the cell on the given workbook.
- the splitted work book should be named as "cell value - macro work book name". and file should be save in .csv format


-----for example: macro work book name is "Book1" and I do have the cell value like "ABC", "BCA", "DAB". so when I split the data to multiple workbooks it should name as below.

ABC - Book1
BCA - Book1
DAB - Book1

Please let me know if you need any further details