Excel spreadsheet: import multiple sheets

[davidmakovoz]

I am importing an Excel spreadsheet. It has 8 sheets.

Each sheet has a header, and the headers are identical.

I found this tutorial https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

It shows <List of Sheet Names> in the 'Table or Query' name.

When I open my excel file, the middle option 'Select a named range' is grayed out. 

I can select one sheet ("Export Worksheet" is the name of the first sheet). 

Is there something I need to install to select multiple sheets?

I Select input dialog 

[joshuaburkhow · Accepted solution]

What you need to do is select "Import Only sheet names..." then you attach that input tool to a "Dynamic Input" tool to actual read each sheet. I've attached an example workflow for you. 

[tomekz1283]

Does anyone have an idea as to how to select only the most recent sheet?  I have a workbook that updates daily with the new sheet name being the date it was created. How do I dynamically select the most recent date? 

Thanks