Iterative workflow

[Chirag_KRCPL]

Given below is the excel data:

Now I want a workflow that combines all excel tabs that contain the word "DEAL". However there can be a case that next time this excel sheet also has an additional tab as "DEAL D"...."DEAL E"....."DEAL X" and so on. So I want the workflow to be iterative that runs as long as the excel tab contains the word "DEAL".

Below is the output that I am expecting (again please be mindful of the fact that this output must be able to incorporate potential new excel tabs that would get added next time)

I have also attached the excel file for reference.

Thanks in advance!!

[Qiu · Accepted solution]

@Chirag_KRCPL 
I think Dynamic Input tool is good fit for the use case here.

We can bring all the Tab names then filter in those containing "Deal".

[Amol_Telore · Accepted solution]

Attaching solution using iterative macro..

@Qiu solution will also work for you if you don't want to use macros..

[Amol_Telore · Accepted solution]

Macro

[Chirag_KRCPL · Accepted solution]

@Amol_Telore  @Qiu Thanks for helping me out!!

[Qiu]

@Amol_Telore 
Glad to be helpful. 

[Amol_Telore]

@Qiu Feelings are mutual.! 😊