Excel vba script to scrape Realtime data

I need you to help me with the on going work to scrap data from a website (which will be mentioned as we discuss )

* Get data from the website in realtime

* copy to an excel

I don't think this would require more than a hour