I would try the Power Query Add-In for this - it can loop over website pages and extract data from them, as long as the pages and their URLs are consistent.
Here's an example:
http://kzhendev.wordpress.com/2014/04/14/scraping-the-web-with-power-query/