Newby here. I'm tracking stocks from finance.yahoo.com, and I need to get the adjusted closing price for yesterday. I can do this by using a web query, pasting the results into a separate worksheet, and then linking the desired cell into another worksheet. The problem is that I want to track a large number of stocks, and I really don't want to have 100 worksheets. Is there a way to do a web query for a specific item in a table?

Thanks in advance for any ideas.......