Macro for Supply Input values & Copy results in Excel from a Redirected Webpage

Dear Members,

I have a webpage that has three input fields. When I put values in the input fields and click on search button, it takes me to another webpage & shows results based on those input values. The webpage URL is masked & it doesn't embed any input parameter/value.
E.g. If I put roll-number in "Search Roll No." and click on search button, then I have been redirected to another webpage with students details.

I want to write a macro for -
1. Loop through the Input values on first webpage e.g. Starting from student 1 to 100
In my case I have 3 Input fields.
2. Automatically click on Button 'Search' & wait till next page loads.
2. Automatically copy the details from next webpage to excel.

Regards,
PK Sharma