Dynamically filling a dropdown box in a web page using an Excel sheet with VBA

[Pravin007]

I have an Excel sheet say A that contains a list from A1 to A75 that has to be dynamically replace the value in a webpage that contains a drop down list.
For each and every replacement value it needs to pull the report from the web page and save that to an Excel sheet B.
All of this function has to happen by clicking a form control button in Excel.
Please suggest & post the code if any.

Regards,
Pravin