split entire workbook by choosing the column (on which column sheets will split)

is there any macro or any feature of kutool excel that cansplit 50 sheets in work book by choosing column or range?scenarioI have 50 sheets with product name and in all sheets thereis column of region. how to I split region wise workbooks with region name and
every new workbook must have 50 sheets of product .