Replacing the existing Data of workbooks on splitting Data in a Master workbook

Hi,

I have macro that which splits data in to different worksheets in the same workbook. Instead of splitting in the same workbook need to split the data into separate workbook and that too replace the existing data on finding whether the workbook (on Name) exists or not. Data split is based on a column (I) value.

On a daily basis I have to work on 80 - 90 workbooks without macro it is hard to rush and thought of getting help from the team.

ABC, WET.xlsx
ERT, ASDSD.xlsx
GIP, WET.xlsx
Master.xlsx

The above are the sample files, Master file is the one main file. All the workbooks will be in one folder. Please, could anyone help me.

Hi Team,

Please could any one help on this..