How do I show the query name in the worksheet over the data cells

[Dancer52]

I have one worksheet that displays the query name over the cells that contain
the imported data and another worksheet in the same workbook that will not
even when I run the same query. I can't find a difference in the script.