Pulling in several Excel files, all have just 1 sheet, but the sheet names are different - erroring

[mmace1]

Hi,

I'm trying to combine the data from quite a Excel files with identical columns.

Every file has just a single worksheet. But, sometimes it's called 'Sheet1', and sometimes it's something else entirely.  The ones that aren't 'Sheet1' are throwing errors.

I'm thinking there must be some simple workaround for this, just I don't know it...? 

Here I've pressed to expand the content, and it shows me the dialogue for the first sheet (where the worksheet is indeed named Sheet1).

 

[mmace1 · Accepted solution]

Nevermind got it - see in the screenshot in my original post, just right click the folder (that in my screenshot says 'Sample File paramater5', then select the only option (edit).  That will pull everything into a table (regardless of sheet name), and let you work from there.