Hello All,

I have for the past 3 years been using excel quite happily to extract data from a site using simple web query. However, now when i try a simple web query it cannot find the table. I have used power query to get the data, as well as libreOffice and Google Spreadsheets all can manage it. Thank you in advance for all of you who will tell me to use one of those ....... if that was the solution i would be doing it. The problem is I have around 100 specific pages i need to mine each of which has its own sheet. I have one sheet with the list of URLs which i used a macro to run and create a new sheet with query for each entry.

I am looking for some advice on how i can either get web query to find the information, is there another option other than to look for table 1? The web pages are all formate the same so it would be easy to find a single identifier which would be on every page. Or is there a way i can achieve the same result using Power Query? I have tried but failed to achieve this and your help would be most welcome.

Thank you for your time
Joffy