Question: how to copy text from one sheet to another in excel automatically?
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.