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.
