Import multiple excel files with different sheet names

[AmulyaSatish]

Hi,

I need to import multiple excel files and fetch the desired sheets. Although the year varies, the sheet names are consistent across files. I want to retrieve the True Up 2022 budget sheet in this case. The True Up 2023 budget sheet will be in the following file. I tried several macros, but only the sheet from the first file was being retrieved. I've included files for your reference.

Thanks!

[caltang]

Have you tried this: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309