Collecting data from websites

I need reliable, data collection from five nearly identical sites. Each page asks me to pick six values from six separate drop-down lists; and a message pops-up on the screen. The data collection will include:

• Dropdown list choices
• the latitude
• the longitude
• the entire text of the pop-up message that appears immediately after the final dropdown selection

I will supply an Excel template that the script must populate row by row. The column order, headers and formatting in that sheet have to remain unchanged.

The main challenge here is the CAPTCHA that fires every time a selection is made. The obstacle isn’t uniform—some sites run Google reCAPTCHA, others rely on traditional text or image challenges—so the solution needs to handle different CAPTCHA types automatically and without manual intervention.