VBA to data Split from column values as new workbook save into folder with dashboard sheet

Dear experts

i need help on my project with vba code...

I have master file in sheet Opencall,column A:A contains some multiple partner name, I want split every partner name as newworkbook save it in same partner name with dashboard sheet with formula into particular path

file save to Path is C:\Users\lara\Desktop\splitedfile


MASTER.XLS contains two sheet OPENCALL and Dashboard..if split the column values from Opencall sheet column A:A


result Aegis Infoware Pvt. Ltd xls along with sheet(Opencall,Dashboard with fomula)
result Aim Enterprises.xls along with sheet (Opencall,Dashboard with formula)


Thanks
find the attachment
Aegis and Aim Enterprises file is my expected result