Hi guys,

I have a huge excel file with several worksheets.
I'm looking for a macro that would enable me to export only certain Worksheets from this file into a separate excel file.
The sheets are: "Overview", "Total", "Accounting", "Controlling", "HR", "Miscellaneous", and "Graph Input".

The output should take over the formatting of the original as well as the name of each tab, however not the formulas behind figures.
The name of the output file can be taken from Sheet ("Overview").Range("M17")

Any help would be very much appreciated!

Thanks!