I definitely think you need a visual basic macro.

Using the "wildcard" asterisk format is an operating system provided facillity
(which will return a list of ALL the files matching the wildcard construction).
I would not expect the standard excel file addressing to cope with this.

However I suspect that a VBA macro might be able to access the operating system facillities that provide this capability.

Try re-posting your query on the excel programming group.

Mark.