Export specific sheet from a file to a specific sheet in many closed files

[Feisty2]

Hello everyone
I have posted the thread at this link

https://www.excelforum.com/excel-programming-vba-macros/1228376-export-specific-sheet-from-a-file-to-a-specific-sheet-in-many-files.html

I have "main workbook" contains a code to create many closed files depending on the column y
where I would like to put a code that enables me to export Customers file to the bank sheet in all closed files Which will be created
How can I modify or add code to proceed with this?
Please have a look at the files
Thanks advanced for help

[Feisty2]

Can someone helps me to solve my problem ? Thank you

[Feisty2]

this seems so difficult or unclear

[SamT]

it's a weekend here. Come back monday.

[Feisty2]

Happy vacation and we are waiting for you


Have a nice time

[Feisty2]

Is that even possible?