Question: how to automatically transfer & save data from one sheet to another in excel?
Answer: Go to Sheet2, click in cell A1 and click on the drop-down arrow of Paste button on the Home tab and select Paste Link button. It will generate a link by automatically entering the formula =Sheet1!