Web query in excel.

Hi, can anyone help me regarding the import of web query in excel. I want to import a table from a site that shows “post” type data and is continuosly updating. My problem is that when im selecting the table through the wizard it only shows the table of that page, whereas the whole data consists of several pages (it shows 10 results per page). How can I select all the pages so that I can get the full data table in my excel?