How to filter sheet name of File 1 based on output of File 2?

[Sudeshna003]

Hello Community

Step 1 : I have an excel file from where I am getting the value of Previous year.

Step 2 : I have another file where there are year specific data in the sheets and the sheet names are like 2023, 2022, 2021...

I want to read the specific sheet from Step 2 which matches Previous year' value from Step 1. How do I achieve this?

I have tried using Join tool but it fails since Step 2 is a list and Step 1 is a string.

Any help is greatly appreciated :)

[Clifford_Coon]

I've had good results building out the file name including the sheet name and using dynamic input using the triple pipe "|||" as a separator before the sheet name.

Example:

 

[Clifford_Coon]

BTW: get sheet name is a macro I use here but isn't required.

[binuacs]

@Sudeshna003 One way of doing this with the batch macro