Read all the sheets from a input excel file

Kaish

I have a requirement where I have a excel file with n number of sheets, the sheets have different date names like 2023,2024,2025 and other sheets are also there with other names which I don't want to read, because the only sheets important to me is the one with dates, how can I read all the sheets from a single input file and then I can work on my data with the different sheets separately, basically here I want to be dynamic with the input, because everytime there can be changes to the number of sheet.

alexnajm

Use an Input Data to import the list of sheet names, use a Filter to get down to only the sheets you want, use a Formula to create the full path with the sheet name replacing the "List of Sheet Names" part, and finally use a Dynamic Input tool to read them in. you can also use a batch macro at the end if the schema are different: The Ultimate Input Data Flowchart