Retrieve Web Data and paste it in excel with different search options

This is my first post and I need help from everyone to solve the issue!!!

I have a data in the spreadsheet as mentioned below and I need VBA to search and get the data from weblink with different clicks..

Sl No Reference Account Details
1 5678943 ABC
2 5678944 DEF
3 5678945 GHI
4 5678946 JKL

My search should be based on the reference number.. Macros should go to https://ABS.com (Example) and login with user ID and password. Post this it has to search the reference in certain field from the webpage (Yet to fix the sarch tab) and click search and next and then copy certain fields to the excel and paste it in last column

I know this would be difficult without the right examples or the weblink for programmer to perform some analysis. However, I need your inputs as I have not done much of programming on the VBA.

Regards,
VINVINSAT

The link does not work. If the site requires log-ins details, I am afraid, you are on your own ,as we would not able to see what is on the source view. To scape data from a site, you need to see the source HTML doc file.