Put the sheet name in a variable called sSheetName and use that:

sSheetName = "Sheet29"
sSQL = "SELECT * FROM [" & sSheetName & "!$A1:gL1000]"

Note that I added an exclamation mark, but maybe it isn't needed in this SQL statement.