build spreadsheet of 500 contacts from houzz

Hi I will provide you with a link to a directory of contacts on [login to view URL] you will need to process the lists of contacts and copy their contact name, website address and find their email address on their own websites that will be provided via houzz. not all contacts will have websites and email addresses. The job is to keep going until you have found 500 contacts with the urls and email address. so to confirm.. .you click a contact, check if they have a website, if they do you click on their website and find their contact email. if you can' complete that process you move onto the next contact and keep going until you find 500.