Splitting an excel table into separate worksheets based on a cell content.

Hello

I have just been presented with a table with approximately 10,000 rows.

The data is financial information, it shows the transactions on individual accounts.

I would like a macro which extracts each account's block of data from the table when a particular label appears in the first column (an indicator for a new account) and puts it into a new worksheet, and then repeats for the rest of the data.  Creating 100 plus new worksheets.

Any help would be gratefully received.

Many thanks

Keith