Welcome to Community!!
Can you try the below code to write multiple excels to single excel in different sheets
Input:
Output:
Sequence2.xaml (17.1 KB)
or
If you want to write multiple excel into single excel in single sheet then try below code
Merging Excels.xaml (18.9 KB)
Cheers!!