Macro to find individual divisions then copy info

Hi Dion

Thanks for getting back to me. In easy terms I want a macro, lets call it 'copy EastAnglia, to look at sheet "DataDrop" search in column B for all rows containing "East Anglia" and copy all data in columns A to M. It then needs pasting via paste special > values into sheet ".1" cell A3.
Cells A3 to M450 would need their contents clearing via a clear contents macro which i can write. This would ensure all cells were emptied before the monthly data drop.

I then need other macros for London, Midlands etc. They need to do the same thing but paste into the next available row on sheet ".1" not paste over any data already there i.e A34 would be next available cell.

Hope this makes sense.
Thanks
Mark

Sample November Targeting Tool.xlsm