Excel: how to make each new sheet automatically filled / edited according to the template?

Question

excel

Good afternoon.
Colleagues, tell me, please, the task is to create a document "Minutes of meetings". It is necessary to make it so that the employee, by clicking on the insert sheet, receives a new one already filled out and edited according to the template. Those. cells of the required size and format, all formulas and drop-down boxes are in place.
And as a bonus, it would be great if you could tell me how to make the sheet automatically receive a name according to the calendar. But, it does not matter, it can be stuffed with your hands.

Answer 1

Perhaps you need something like this:
https://habr.com/ru/post/344956/
https://habr.com/ru/post/359218/
here are 2 of my articles on Habré about automatic output to a . xls(x)/.doc(x) data from an Excel spreadsheet. There are 2 approaches, the first one is through macros and the approximate code of such macros is indicated in the article, and there are even working programs that were posted by me in the public domain here:
https://vk.com/softpto
on the other hand, you can do the same through the merge wizard , but there are 2 big differences, the merge wizard works all the time and any deviation is automatically reflected in the copy of the template, and macros ... they need to be launched by a button. Both methods have pros and cons.