Output Sheets into Separate Existing Files

[Brook_G]

Hi!  I am hoping someone here might be able to give me some guidance.  I will try to explain what I am trying to do as clearly as I can, it might be a bit confusing.  I currently have a workflow which outputs hundreds of separate Excel files.  Each output file has  one tab, and each of the files is output/saved into a specific destination folder on my computer with different client names.  Up to this point it is working great.  My issue is this: After the outputs are ready in my destination folder, I need to copy sheets from existing Excel files provided to me from a different work department into the corresponding files from my Alteryx outputs.  For example, Alteryx output file for client "A"  has 1 sheet.  Coworkers provided me another file from client "A" with multiple sheets of existing data.  I need the multiple sheets from my coworker's file for client "A" to be combined into my Alteryx output file for client "A".  Same with files for clients "B", "C", and so forth. Any ideas on what I can add to my workflow to let Alteryx do this part? I attached a screenshot of my workflow.     

[T_Willins]

Hi @Brook_G 

Do the files provided by the other department only have the sheets needed to add to your Alteryx output and do those filenames match your output?  While a complex solution can be done in Alteryx to move sheets over to the Alteryx Output using the Run Command tool and some VBA code, a simpler solution might be to copy the files from the other department into the destination folder of your Alteryx Output tool and add the Alteryx results to the existing copied workbooks.  Let us know if this doesn't work for your situation and we can provide additional guidance.