Macro with dynamic Sheet names

The names of my worksheets vary depending on what a user enters into a cell, and I need to reference these sheets in a separate macro.

So, I can't use this for example:

Sheets("Data").Select
    Range("A2").Select
    Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

because it refers to Sheet "Data" when I need it to refer to Sheet1 as it is labeled in the VBA Project Window.
Any ideas?