Macro to seperate tables based on column b

Hi All,

I have a table from columns A to K with no specific number of rows as this can vary.

Row 1 is the header of the table.

In column B, row 2, I have a name and the cells under are blank up to the next name and so on.

I would like to seperate the table based on the intervals in column b, so a new name starts a new table in effect using the header from row 1.

If the new tables can go on their own sheet too, whilst keeping the same formatting as the original, that would be ideal

Any ideas would be much appreciated.