Macro to Create New S/Sheet When a Change Occurs - Excel MASTER required!!

Hi Guys,

I have a s/sheet of 3k+ rows of data. I need to split this document by business area and save them into individual files. I need someone's help to produce a macro that will look in the business area column and automatically create a new s/sheet document with each of the individual business areas.

The attached should help visualise the requirements,,,thanks!