Question: how to copy one sheet to another sheet in excel automatically?
Answer: Start Excel. ... 
Click the New sheet button at the bottom of the screen. ... 
Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets. ... 
Click in cell A1 in Sheet1, and then type: