During the transformation, can we use a wildcard for the from clause?

Example:
Worksheet name could be sheet1$ or sheet50$

SELECT [Num], [Server], [PNum]
FROM ['Sheet1$']
WHERE ([Server] IS NOT NULL)

FROM like ['Sheet%$']

or can I get the worksheet name with out having to install excel on our
SQL processing server?

Thanks