How to use Table variable into SQL query instead of sheetname

Example is -- select * from [Sheet1$$];

I want to use Table Variable instead of Sheet1

I tried to using ---   select * from [Table variable$$];

It is not working , can anyone suggest solution