Fetching data from link using excel macro FOR 50,0000 entries!!!!!!!!!

I am a complete beginner.... i have to fetch data from a link"http://tanca.annauniv.edu/tanca13/rankngate.html" using input data tancet registration number.
the following details have to be fetched
Name, Community, Branch, Tancet mark, Overall Rank, Community Rank

Sample numbers for input data:
There are three possible outcomes they are
11543222 Valid ( for this all details are to be fetched as mentioned above)
18143268 Rejected (for this all details have to be fetched except community rank & overall rank)
12113598 Invalid (for this NA has to be updated in the excel sheet)

More info:
50,000 entries are there totally in excel sheet.
Outcome expected is the excel should be updated with the fetched data for corresponding tancet number.

Thanks in advance.