Question: how to copy excel sheet to another sheet with same format automatically?
Answer: Right click on the worksheet tab and select Move or Copy. Select the Create a copy checkbox. Under Before sheet, select where you want to place the copy. Select OK.