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.