DATA ENTRY JOB- Copy some public data from 3 websites on to spreadsheets for us

I need to collate Microsoft Excel marketing data to sell our services. The data is available on 3 websites as described below. Instructions for each of the three DATA SOURCEs are as follows: --------------------------------------------------------------------- EXCEL FILE 1: [login to view URL] --------------------------- 1. Copy the register of all agents from the following website (there are 107 pages): [login to view URL] You need to COPY and PASTE data correctly in sequential order as per data presented on each page on to an excel worksheet called UK ALA. The columns you need to populate are as follows: a) Serial Number (1, 2, 3, .... 958.... 1072 etc) b) Company Name: c) Address FIRST LINE: d) Address SECOND LINE: <Leave empty if no second line> e) Address POST CODE: <Example AB12 3CD> f) Telephone Number: g) Website Address: h) Email Address: i) String Concatenate Column to form the complete Company Name and Address that can be directly printed on the envelope using mail merge. EXCEL FiLE 2: [login to view URL] ----------------------------- 2. Go to [login to view URL] Scroll down to the "Browse letting agents by area" table. a) We need to extract ALL RECORDS for London (4716) and South East (3108) records. b) Create two worksheets, one called LONDON and another called SOUTH EAST ENGLAND. c) Now drill down through all the sections of London on the website (East London, East Central London etc). d) Drill down one level further on a new page. This is fairly easy. e) Now, once by one drill through each Postcode area, and copy paste the following columns on to the respective excel spreadsheet: - Serial Number (1, 2, 3, .... etc) - Company Name: - Address FIRST LINE: - CITY : (Eg: London etc - the city is written just before the post code) - POST CODE: <Example AB12 3CD> - Telephone Number: - String Concatenate Column to form the complete Company Name and Address that can be directly printed on the envelope using mail merge REPEAT THIS FOR ALL THE REGIONS ON THE TABLE (East Midlands, East of England, North East England,...., Wales, Northern Ireland). Each Region should be on a separate worksheet on the excel ZOOPLA.xlsx. EXCEL FiLE 3: [login to view URL] ----------------------------- 3. Go to [login to view URL] and select Radius = "Within 40 miles" of London for all Agent Type = Sales and Lettings. a) There are about 50 page scrolls of search results shown. b) For each agent listed, click the 'About this agent' link below. Copy and paste the company's details in an excel list with the following: - Serial Number (1, 2, 3, .... etc) - Company Name: - Address FIRST LINE: - Address SECOND LINE: - POST CODE: <Example AB12 3CD> - Telephone Number: - String Concatenate Column to form the complete Company Name and Address that can be directly printed on the envelope using mail merge Now, repeat the above exercise that we did with "London" for the following keywords but with Radius = "This area only" Bedfordshire Berkshire Bristol Buckinghamshire Cambridgeshire Cheshire City of London Cornwall Cumbria Derbyshire Devon Dorset County Durham East Riding of Yorkshire East Sussex Essex Gloucestershire Greater London Greater Manchester Hampshire Herefordshire Hertfordshire Isle of Wight Kent Lancashire Leicestershire Lincolnshire Merseyside Norfolk North Yorkshire Northamptonshire Northumberland Nottinghamshire Oxfordshire Rutland Shropshire Somerset South Yorkshire Staffordshire Suffolk Surrey Tyne and Wear Warwickshire West Midlands West Sussex West Yorkshire Wiltshire Worcestershire The data should be copied with CARE and in SEQUENTIAL order.