Generate separate workbooks from main Workbook

Hi there,
I have a spreadsheet with work sites located in Irish counties in a spreadsheet. The county that the site is in is located in column A, and there can be anything from 1 to 100 sites per county. I need to filter out all the sites in one county, copy all the data (column A to Column FF or something), paste this as transposed data in a new WB, and complete this for all the other counties.
There are currently approximately 200 sites. I have a macro, but it is going to be very long winded as I don't know how to get it to run auutomatically for each county, so I am just reproducing the action for 20 odd counties. Can anyone make this shorter?
Thanks in advance

Thanks guys, I started fiddling with the first code provided by WasWodge and it did what I wanted after I changed a few things. Sorry about not providing the Excel sheet, I attach the one showing how far I have got with the macro. It is populated with false data but it shows where the data would be!

Now that I have extracted the data I need two more things.
1) on each sheet it needs the headings from the original sheet...there are three or four rows with important headings above all the data which is required in each summary sheet.
2) I also need to transpose everything when it is moved to the new sheet, so that instead of presenting horizontally, it will be presented vertically. I think this is achievable by using an intermediate sheet, but I'm just wondering where to start.

Thanks so much for your help!