Question: how to transfer data from one worksheet to another in excel automatically?
Answer: Copy and Paste Link. ➢ From source worksheet, select the cell that contain data or that you want to link to another worksheet, and copy it by pressing Copy button from Home tab or press CTRL+C. ... 
Enter formula manually. ➢ In the destination worksheet, click on cell that will contain link formula and enter an equal sign (=)