Simply useing direct cell reference:
SELECT [Value] FROM [Sheet1$] WHERE [ClientID] = T1
or
SELECT [Value] FROM [Sheet1$] WHERE [ClientID] = [T1]