Web Query with Yahoo Finance

Hi all,

Im not even sure if this is possible but could be interesting if it is!

I currently use a web query to check on a single stock which update (obviously) each time i open the worksheet.

The problem is i have multiple sheets for all the tsock and each time i want to add a stock i have to do a new worksheet.

What would be cool is for a msg box capability, so that i press a macro button, type in the symbol and it then gives me the tabular information as per the original query.

Is this possible?

I have attached an example of the data i am currently capturing for Tyco.

Any thoughts on this would be greatly appreacited