Directory Scraping

I want to scrape a number of directory websites and take the business data from them and organise them into spreadsheets. I want the spreadsheets to be made in the Sheets on Google Docs. The columns in each spreadsheet will be as follows: Business Name, Address, Phone Number, Email, Contact Name, Service Type (Listed below) and Source (e.g Yelp, Checkatrader etc.). Here is a list of the websites I want to be scraped: [login to view URL] - Home Maintenance [login to view URL] - Home Maintenance [login to view URL] - All [login to view URL] - All [login to view URL] - Event Services [login to view URL] - Lessons [login to view URL] - All [login to view URL] - All [login to view URL] - Lessons [login to view URL] - Moving Home [login to view URL] - Removals [login to view URL] - Moving Home (Estate Agents and Letting Agents) [login to view URL] - Legal Next to each one of these websites is a sub category (e.g Legal, Home Maintenance, Events etc) For each website I only want the sub categories specified. There are 121 categories which are broken up into the following 9 sub categories: Moving Home -Removals -Survey -End of Tenancy Cleaning -Storage -Conveyancing -Estate Agent -Letting Agent -Home Insurance Event Services -Photography -Catering -Photo Booth -DJ -Florist -Bar Rental -Event Hair Styling -Event Makeup -Karaoke -Wedding Band -Wedding Cakes -Audio and Visual -Belly Dancing -Face Painting -Balloon Artistry -Limousine -Videographer -Table Dressing -Event Insurance Lessons -Maths Tutor -English Tutor -Languages -Tennis Coach -Guitar Lessons -Piano Lessons -Violin Lessons -Dancing Lessons -Swimming Lessons -Driving Lessons -Boxing Pets -Pet Grooming -Pet Sitting -Pet Walking -Pet Insurance Wellness -Personal Training -Yoga Lessons -Massage Therapy -Counseling -Hypnotherapy -Acupuncture -Tarot Card -Mobile Hairdresser -Nails -Waxing -Spray Tan -Teeth Whitening -Chiropractor -Life Coach -Nutritionist -Physiotherapy Cleaning -Cleaner -Oven Cleaning -Carpet Cleaning -Window Cleaning -Upholstery Cleaning Maintenance -Handyman -Plumber -Electrician -Roofer -Glazier -Decorator -Gardener -Landscaper -Plasterer -Tiler -Tree Surgeon -Scaffolding -Junk Removal -Skip Hire -Pressure Washing -Drain Clearance -Insulation -Solar Panels -Pest Control -Roller Shutter -Fencing -Floorer -Bathroom Fitter -Asbestos Removal -Locksmith -Cabinetry -Home Theatre -Carpet Fitter -Stone Mason -Bricklayer -Groundworks -Heating Engineer -Gas Engineer -Home Security -Paving -Interior Designer -Metalworker -Chimney Sweep -Fireplace Installation -Kitchen Fitting Auto -Mechanic -Mobile Valet -Windshield Repair -Mobile Tyre Fitting Legal -Accident and Injury -Consumer and Civil Rights -Crime -Employment -Family and Relationships -Houses, Property and Neighbours -Immigration and Changing Countries -Money and Debt -Social Welfare, Health and Benefits -Wills and Probate There are a list of 52 cities that I would need to separate them the data into: London Birmingham Leeds Glasgow Sheffield Bradford Edinburgh Liverpool Manchester Bristol Wakefield Cardiff Coventry Nottingham Leicester Sunderland Newcastle upon Tyne Brighton Hull Plymouth Stoke-on-Trent Wolverhampton Derby Swansea Southampton Salford Aberdeen Westminster Portsmouth York Peterborough Dundee Lancaster Oxford Newport Preston St Albans Norwich Chester Cambridge Salisbury Exeter Gloucester Lisburn Chichester Winchester Londonderry Carlisle Worcester Bath Durham I'd like to divide them up in 52 spreadsheets, one spreadsheet for each city and then divide them into the sub categories within the spreadsheet. I hope this all makes sense to you please let me know if you have any questions.