Dear Community,
I have been unable to find a solution to this in the current posted discussions, but please let me know if this type of issue has already been resolved.
Current Status:
Data Source File.xlsx with Tab A
Company A File.xlsx
Company B File.xlsx
Company C File.xlsx
Desired Outcome:
Company A File with Tab A
Company B File with Tab A
Company C File with Tab A
Is there a way to add a specific tab from a source file to all Excel files in a given folder?
Thank you in advance for your help.