I can do this sort of thing:
Select * FROM [Sheet1$]

but not if the worksheet is called 'Contracts & Licences'

What brackets etc would I need?
Renaming the worksheet would be a last resort because it is used by non-techies

Alternatively, is it possible to access a worksheet by an index value?


Thanks