Question: how to automatically copy cells in excel to another tab?
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.