Input Only Selected Sheets from One Excel File (multiple sheet import)

[Nieves_2023]

Hi, 

I'm trying to input only sheet names that contain "TXG Summary Claim" from the file attached but I have not been able to successfully import. I have seen a few discussion suggesting to use the "Select Name Range" option in the input process but it's greyed out for me. I have also tried to use Dynamic input but I couldn't make it work. 

Does anyone have any suggestions on how to achieve my goal of only importing tabs that contain "TXG Summary Claim"?

Thank you in advance!!!

[CoG · Accepted solution]

Here is a workflow that uses the Dynamic Input tool to accomplish your requirements.

[Nieves_2023 · Accepted solution]

Thank you Andrew, this was very helpful. It worked!