Scrape Business Contact Information from 2 Websites

I need some information scraped from 2 websites into 2 different spreadsheets. For anyone submitting a response to this job please send me a sample using the attached spread sheets so I can confirm the information is being collected correctly. (2 complete business entries per Excel sheet as a sample please). THE JOB: I have created the 2 Excel documents with different tabs in each based on the businesses that are located in different parts of Australia. For both tasks information needs to be scrapped and copied/pasted into the Excel documents. I require the following information to be copied and pasted: - Business Name - Website URL (or Facebook page URL if no website is provided) - Email address - Phone Number - Address TASK 1 - Craft Beer Reviewer [login to view URL] Task Explained: There are 12 different tabs created in the document named "Craft Beer Reviewer Contact List". Each tab is for different state/area in Australia. At the top of each spread sheet tab (Cell A1) I have copied the relevant URL address from where the content needs to be scraped. Visit this URL for each Excel spreadsheet tab and go through the list of breweries and copy and paste the different business details. Note, the Craft Beer Reviewer website is missing the email address for each brewery. To get the email address for each brewery you will need to visit each breweries website URL or Facebook page (if provided) and collect it from their website, e.g. from their Contact Us page on their website or from the About Us / Page info section on Facebook. For any website URL, email or address which is not available enter an "NA" into the excel spread sheet. Each tab in the Excel spread sheet needs to be filled with scraped data. TASK 2 - Crafty Pint [login to view URL] Task Explained: There are 6 different tabs created in the document named "Crafty Pint Contact List". Each tab is for different states in Australia. When you are on the website [login to view URL] you can filter the venues that are listed by using the buttons at the top, e.g. click "Victoria" to just show the Victoria venues. These are the venues you will enter into the "Victoria" Excel sheet tab. Once you have filtered the state using the button you will need to click into each of the venues listed, e.g. "Atticus & Finch". Once you have clicked on the venue you will be taken to the venue page and this is where the information will be scraped from. On the right hand side there is all the information required. Note, the website URL and email are hyperlinks. To copy this information you will need to follow these steps: 1. Hover over the word "website" with your mouse and then right click and select "Copy Link Address". You can then paste this into the Excel document. 2. For the email address you need to hover over the "email" icon and do the same thing, i.e. right click and select copy email address and then paste into the Excel document. For any website URL, email or address which is not available enter an "NA" into the excel spread sheet. Each tab in the Excel spread sheet needs to be filled with scraped data.