web scraping

Hello,
I need to do a macro when I type the site in a cell
it extract a table from that site to the rest of the row
and I need to do it repeatedly to the rest of the rows
till now I can only do it to one row only and it is msgbox

This is the code I used

Please Login or Register  to view this content.

and I will attach the html code of the site...

pastedImage.png