I need to link a cell to an external spreadsheet with a specific name format and I'd like to do something like this:

='[spreadsheetname_*.xls]sheet1'!$A$1

but excel doesn't allow wildcards here

Is there any way around this?