Dynamic Excel Web Querry

I would like to create an excel tab that querries financial websites like ADVFN, yahoo finance and others for 10 years of historical financial data, current stock prices, current analyst estimates, etc. I would then like the sheet to update that information to the most up to date whenever I querry. For instance, if I create the querry for 10 years of financial data from 2004 to 2013 and 1 week later, 2014 data is published, I would like it to automatically query 2005 to 2014. Further, I would like the query to reference any stock symbol I input into cell A1, B1 or nearby cell. The output does not need to be pretty but needs to be flexible and well labeled. I have historically used MSN for this but they recently reformatted the site and I have not been able to get a similar free site (mostly ADVFN) to work-- mostly because I lack the programming skills to make it work the way I would like.