Question: how to copy sheet and rename automatically in excel?
Answer: Copy a worksheet and rename based on cell value with VBA code.
Copy a worksheet multiple times and rename based on cell values with Kutools for Excel.
Activate the worksheet that you want to copy, and then hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.