that site requires login to related page.
this may help with this.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=399

then you must google stg like "excel vba pull data from web"
here is a sample:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=576