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

Question

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!!!

NAT_FIN0_Claim__Summary (16).xlsx

CoG · Accepted Answer

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

Nieves_2023 · Accepted Answer

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