Copy Worksheet Tab into another Worksheet File

Is it possible to take a Master.xlsx with a worksheet tab name called "Summary" and copy the contents of that tab and add it as another tab in another .xlsx file with the same worksheet tab name? Better yet, copy that worksheet tab into a group of .xlsx files in a directory of choice?

Thanks.

Hello

1) If you select add data into exiting file it will create new sheet within exiting excel file and copy data.
2) it is possible to loop through tre list of files and add new sheet to every single one of them by using variables, Loop package object and file opration.

I suggest you try task one fist once it is working as expected we can assist you with taks number two.