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