I'm a little confused by what you're describing as the layout of your data. If you do a web query, why do you need to copy & paste the data to another worksheet? Why not just link directly to the data provided by the web query?

You can do as many queries as you want on a single worksheet, then link the particular cells you're interested in on another. I don't see a need for more than two worksheets.

My understanding of how web queries work is that you can only identify a table to import, based on Excel's analysis of the HTML code. You cannot identify a single cell in the table to import. There may be such a way to do something like that using VBA but I have not used VBA to try to retrieve HTML from a URL.