Copy a complete Excel sheet (incl. formats, formulas etc)

Hi there,

I feel like I have been doing this before, but I might be completely mistaken.

Here’s what I want to do:

I want to copy a whole Excel sheet incl. formulas, formats and everything into a new file. Don’t even want to transform it in any way. I just want to take the sheet and overwrite any sheet in the new file that has a similar name.

The reason is pretty simple:
My users have a sandbox Excel sheet in a file that is otherwise heavily templatized. Lots of locked cells etc. But in this sandbox file, they can do whatever they want as an additional “calculation” (want to build an avergae revenue instead of the sum of revenues as per the standard sheet? > go to sandbox and do it there).

The problem is, the overall process this Excel file covers will repeat every month. Now my users have the fear, that they need to “redo” their sandbox calculations every single time (aka every month).

As I said, the idea of “copy pasting an Excel sheet as is” somehow rings a bell with me and I feel like this should be “easy” but that might just be me, confusing some things.

One important sidenote: Unfortunately I cannot use Python (e. g. openpyxl) as this is something my customer needs to maintain and they basically have no one who “speaks Python”

Any feedback would be highly appreciated.