Need vba to split unique rows of column H,G,I from sheet of East,West,North

Dear expert

I have (Freak) master consolidate report with three multiple tabs i want split same unique rows from three sheets from column of H;G;I and make as newworkbook with unqiue values with same sheet names to target path

Mypath is D:\Jews\Forum\forums

for e.g TE001 rows in three sheets col of H:H EAST,col of G:G WEST,col of I:I NORTH.....want make single workbook as TE001.xlsb...till end of unique rows.

please find the attachment.

Freak is master file...TE001,TE002,....etc out file

Ok, I had a go at solving your problem.

I've made a file named "Model.xlsb". This file is identical to your "Freak.xlsb" except that this file contains no data aside from the headings in sheets "EAST", "WEST and "NORTH"

This file should be put in folder "D:\Jews\Forum\forums\"

The file "Freak_mod.xlsb" is your master file with a macro. Put it in whatever folder you like. To test run macro "MakeFile"

Macro first find all the unique "TE00?" values, it then sets an autofilter on sheet "EAST" with first "TE00?" value, copies the result and opends the "Model.xlsb", activates sheet "EAST" and past the result, activates "Freak_mod.xlsb" and uses same "TE00?" value for an autofilter on sheet "WEST" copies the result to c and activates "Freak_mod.xlsb".

After the last values from sheet "NORTH" is copied to "Model.xlsb", the file is saved using the first "TE00?" as a file name to folder "D:\Jews\Forum\forums\".

Then the macro uses the next "TE00?" for the autofilter and opens the "Model.xlsb" to catch the values from this run and so forth .....

Alf