Copy Rows into a new sheet if a column has certain text entered

Hi Everyone

I am a newbee to VBA, but have been given a challenge by my boss.... I have a spreadsheet that in column D has upward of 20 different areas (Birmingham, Manchester, Gillingham etc...).

What I need is something that will identify all the rows with Birmingham in and copy those rows to Birmingham worksheet, all those with Manchester in and copy them to the Manchester sheet etc etc etc.

A code that would create the sheets as it encounters a new area would also be a massive bonus.

Any help is appreciated.

Susie