Join Multiple Excels with Multiple Tabs into One Output with all tabs

[tgoodge]

Hello Folks,

I hope you are doing well! I am struggling with a task that I have seen a lot of similar processes for but I cannot get to work for my scenario.

I have three spreadsheets, all with 12 tabs. I am looking to create a routine that will combine all three spreadsheets into one with 36 tabs.

IE: Salesforce Data, Product Sales Data, Revenue Data.

I do NOT want the "Salesforce June 2023," "Product Sales Data June 2023," and "Revenue Data June 2023" data to be on the same tab, but I want them next to each other. Can I get some help? This is as far as I got before I got stuck..... 

[binuacs]

@tgoodge would you be able to upload some sample data and expected output?

[tgoodge]

Yes! Here are the 3 test files and the goal "output" for what I'm going for. 

[Qiu]

@tgoodge 
I usually use the worflow to import multiple file with multiple sheets as below.

[tgoodge]

Thank you so much! I will take a look at this solution and see if I can get it to work for me. I appreciate it! :)