If I understood you correctly. You can create User DSN with "Microsoft Excel Driver" in the ODBC Data Source Administrator section. After that connect using the same ODBC, you can retrieve the sheet names of the excel dynamically.
ODBC CONNECT32 TO [QV Excel ODBC1;DBQ=D:\QV Test.xlsx];
for i = 0 to NoOfRows('ExcelInfo')-1
let vSheetName = PurgeChar(PurgeChar(peek('TABLE_NAME', $(i), 'ExcelInfo'), chr(39)), '$');
if left(vSheetName, 2) = "20" then
$(i) as IterNum,
(ooxml, embedded labels, table is [$(vSheetName)]);
No sure which of all replies you refer to, but all examples should work in Sense as long as you change the path to a lib path.
In my example above, this is the Sense version:
for each vSheet in 'Sheet1','Sheet2','Sheet3'
'$(vSheet)' as Sheet
(ooxml, embedded labels, table is $(vSheet));