fetch public information into excel

Project details: We will provide you a website with publicly available information. We can show you the website address in PM. This website provides ability to search for companies using different methods, but limits to 500 results. Example: When you search this website select by Name, enter letter "A" to start with and press enter. Only 500 results will appear. But if you enter AB different set of 500 results will appear. Use this and other methods to gather all the records from this website. Your task is to create a script that will fetch all the data from the website. Once you search: 1) List of companies will appear 2) If you click on the company name, details about the company will appear 3) you will need to gather information like entity type, out of service, legal name, DBA name, physical address (separate fields for street address, city, state, zip code), mailing address (separate fields for street address, city, state, zip code), phone number. 4) organize this data to excel. Each field should have a separate row 5) delete duplicate records from excel 6) Email us final excel sheet If you have any questions, let me know in PM.