To get other dates for the same data (i.e. historical) you will need to send a form variable to the web query with the date value in the format required by the page: DD-MMM-YYYY. The form variable name is "TxtDate". To find out how to add post form variables in a web query, see this post.
You best approach would be to create a separate page for the web query results, loop through the dates required and with each call extract the data that you want into the desired sheet in the format that you require. For this, you will need to loop through the dates in column B using a For Each...Next loop to call the web query with each date.
