Adding Tab from One File to Multiple Files

[skalgaonkar]

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.

[afv2688 · Accepted solution]

Hello @skalgaonkar ,

There is a way to do it yes. For example like this.

Regards

[skalgaonkar]

@afv2688 

Thank you so much!  I have not used the Directory tool yet.  I'm glad there is a relatively simple solution. 

I appreciate your help!