vba code for copy specific data to another sheet

dear all,

since i am new with vba stuff need some help on below situation

I have master sheet where in column a has names, All I want is filter name of each name and copy and paste the data into new workbook with the name of filtered name and with filtered names as sheet name

like if filter with rishi then new work book with name of rishi and worksheet name rishi and in there rishi names filtered data

pls find below is the attached dummy data

many thanks
Rishi Saw