The easiest way to resolve this is:
Move the code for Sub RefreshQuery into the module for Sheet1
Change the call to the sub from
Change the following code
where Sheetx is the name of the sheet containing the stock symbol
If you still have trouble, post your entire workbook instead of just the code.
It looks like you just copied my query instead of creating your own. I don't know where you expect to get Total Assets from; it's not on the page. A web query returns tables selected from a web page. It doesn't retrieve the whole page or arbitrary text. If you right-click on the data from the web query and click on Edit Query you'll see the green checkmark to show what is selected on what page.
Also, I do not get "Total Assets" as the output from the webquery