Imort multiple sheets from file, Look for number beside string(vlookup)

[wonka1234]

Hi,

1) I am trying to import all sheets from file that start with "CHT1".

2) I am only wanting to extract values next to "Current Month Principal for Reinvestment". Almost like doing a vlookup in each CHT1 sheet.

For example, looking in each sheet for this, regardless of cell position.

How can I import these values for each CHT1 sheet?

Thanks.

[binuacs]

@wonka1234 the input tool only returns the sheet names from the given excel sheet and feeding to the macro, the macro just uses the full path and the sheet names and read each sheets and stacks to one another like a union tool. Since you have different schemas only the bactch macro is able to read those records. if you look at the below post you will get much idea on this

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten