I am importing data from the internet but just selecting a small number of tables from the internet pages (Some share price data and analysts estimates). My problem is that every so often the selceted tables are de-selected and either no tables or random tables are pulled through instead. I have not been able to write a macro to pull through just the selected tables. Has anyone else had this problem? Is there a way round this.

Example page imported would be:

http://uk.finance.yahoo.com/q/ae?s=LLY

Do a Data, Import External Data, New Web Query

Tables selected are Company Name: Eli Lilly & Co. (LLY) in this example
Earnings Est
Revenue Est

It is the latter 2 that keep being lost/reset

Thanks for any help on this