Copying sheets from different files into a single file

[visual90]

Hi,

I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file.
Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed.
While preserving existing cell format/style.

Something equivalent to going over each sheet and copying all the data into a new sheet in a single(new) Excel file (and keeping the format/style - I've found some scripts that dont preserve styles, like pandas in python).

cross-post:
You are not allowed to post any kinds of links, images or videos until you post a few times.

Thank you.

[KOKOSEK]

Please read forum rules. Especially p. 3.
Cross-post: https://www.mrexcel.com/board/thread...-file.1190884/

[visual90]

Oh wow it's a different forum isnt it though? it's not like a son-forum of this forum or something right? I though I'd post on different forums to expose my question to as many unrelated people who might know the answer...

[KOKOSEK]

Sure you can post into various forums. But you should inform about it.
Please read Forum Rules, it is not so long.