Creating New Sheets from Main Sheet

Hi,

So, i'm new to excel and perhaps someone can point me in the right direction; what I should be looking at.

I have an excel sheet, with data on it.

This data has a colomn 'N'; which specifies a 'Group' (North, South or East) (data of groups via 'vlookup' from sheet 'CLIENT LIST')

What I am trying to do, is to be able to split the data on three seperate excel sheets automatically. (OR even better different workbooks are created)
'NORTH CLIENT', 'SOUTH CLIENT' and 'WEST CLIENT' (see the tabs which are colour coded GREEN - (this would be the end result)) and the name of each single sheet is renamed to the 'CLIENT GROUP'.

Any ideas?

Thanks.
Sam