In my first worksheet I have a list of states and state abrivations I want to refreence each of the states and return their results on a new worksheet. I've been able to scrap together most of the code, but i'm missing the first part of the code which declares the reference...I Think?!

Looking forward to you input, thanks!

        MyName = "Query" & State
        ConnectString = "URL;" & State
        ActiveSheet.Name = State
        ' On the Workspace worksheet, clear all existing query tables
        For Each QT In ActiveSheet.QueryTables
        Next QT