Get multiple sheets(sheet name are dynamic) from multiple files

Hi,

If we get data from 'Sharepoint folder' then we can get multiple excel files no matter how many files are there.

e.g. if there's 2 files then get 2 data sources, 4 files then 4,,, it can get data dynamcially.

so we can compare their each data in one dataset.

Likewise, can we get multiple sheets from multiple files? 

e.g. sometimes the file has 3 sheets(but same format), sometimes it has just 1 or 2. 

As we know, when we get the data, we need to specify the source from which sheet name or sheet order.

so my question is, can we get all the sheets no matter how many and what the name of sheets are dynamically?