Fill in a Spreadsheet with Data

Hello. I have the attached spreadsheet which I need completed. It is a list of the names of 224 cafes in Sydney, Australia. Here is what I need done: - You will be working on the "Consolidated" tab. The other tabs are there only for reference purposes so that you can see where the initial search was performed. - Some entries have some data in the "List Information" field. You are to extract this information and place it in the correct cell in the "Address", "Web" or "Phone" fields. - Where the information is not available in the "List Information" field, you are to find it (using web search, web sites or other means) and input the data into the "Address", "Web", "Phone" and "Email" fields. - The "Address" field must contain the cafe's street address in the following format: Street Number, Street Name, Suburb Name, Post Code. These elements must all be in the one cell, comma-separated. - The "Web" field must be populated with the cafe's web site. If the café has no website (very unlikely), then something else like facebook page etc. must be input here. ALL entries in this field must be HYPERLINKS which open the cafe's website in a web browser and it must be clickable directly in the Excel cell. - The "Phone" field must be populated with the cafe's business phone number. The owner's mobile number is acceptable ONLY IF the café does not have a business number. - The "Email" field is THE MOST IMPORTANT field. It must be populated in all cases - I will not accept the list as complete if any entries do not have an email address entered. ALL entries in this field must be HYPERLINKS which open the cafe's email address in Outlook and it must be clickable directly in the Excel cell. Please let me know if you have any questions. Good luck and happy bidding!