Question: how to copy a row in excel to another sheet 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.