Question: how to automatically copy data from one sheet to another in excel using formula?
Answer: Copy and Paste Link. From source worksheet, select the cell that contains data or that you want to link to another worksheet, and copy it by pressing the Copy button from the Home tab or press CTRL+C. ... 
Enter formula manually.