Hi,
Please provide vba code to open website and login with user id and password then click on the link and copy data.
Once the page reach data it takes time to load then once data populate then copy and paste to new excel sheet with the any name or I will provide the name list.