Edit Multiple Excels To Match Master Template (I.E. Table Headers, Sheet Name)

I need to edit about 2,000 excels to match my Master Template. The Master Template contains adds extra columns, removes some columns, and a rename of the sheets. The 2,000 excels should be uniform. Would there be any method of automating this through a VBA? Or is this not possible.
I can provide any additional details if needed. Thank you for taking a look.

I apologize. I have around 2,000 excels in which we use to log data. We're updating the template of these logs. Without any excel magic, I would need to enter each log and change them to match our Template.

Sheet 1 (Summation):
Swap Column H and I.
Copy & Paste A1:J1 from the Master Template (Sheet 1) to the other excel.

Sheet 2:
Clear column C
Delete Column I
Clear Column K (or delete) either or
Copy & Paste A1:J1 from the Master Template (Sheet 2) to the other excel.

Rename Sheets
"Summation" to "INPUT (PROCESSING)"
"Production" to "OUTPUT (PRODUCTION)"

I've never tried or even thought of anything like this so I don't even know if it's possible. I figure I might be able to come up with a macro since it's the same steps over and over but as far as making a script to open every excel and execute the macro, I wouldn't know where to start.

What I'm picturing, sorry if it's absurd, is opening a macro excel. Running a script that says opening 1st workbook, perform the macro to edit the excel, save and close the excel, go to the next excel. Do you believe this is possible?

Sheet 2:
Column C did not clear
Row 1 did not copy from the Template. I'm sorry. Not sure if I specified this correctly.
Everything else worked great.

I was able to figure out what I needed by disseminating your code and one or two more out there. This is what I came up with which works great.

I run it in my Template workbook and it opens excels in the specified folder, performs the operations I want it to, saves, closes, and goes on to the next.

Thanks for your help.

Please Login or Register  to view this content.