Break a excel file into various excel sheet based on a column

Sir

i am attachinh here with a sample of my excel file,inwhich ,i want that my this sample file can be breaked into various excel files based on coulmn b of my sample dummy sheet.

Row 1 in my file is a header: Which should come in every excel file as first row as header after they breaks in parts.

Then items in column b are like:5,6,25,12,16 and like wise. So seprate files with the name 6,25,12,16 and like wise need to be created seprately and intems belongs to 6,25 and likewise sholud come in the corresponding excel files.

Thank you