Scraping Data from a URLs List Into Excel Using VBA

I have a list of several hundred URLs in Excel. The URLs are all from the same site and have the same format and structure, but the specific data on the page varies (example about one URL: http://finance.vietstock.vn/DPM/1/co-dong-lon.htm. I am hopeful that there is a way to do this using VB, but I have not been able to get it to work.

I have successfully used a Web Query for one of the URLs from my list (the link above) into Sheet 2. My workbook have two sheet: Sheet 2 with the result from the above URL and Sheet 1 has the URLs list. Now I need an automated solution that will look up the next URLs in the list, run the Web Query and download new data to new sheets (one sheet for one URL).

Does anyone have any pointers how to do this? Or perhaps a better way to accomplish this than using VB? Thanks for your help!

P/S: This is my file, for your reference.

https://drive.google.com/file/d/0B3g...ew?usp=sharing