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