Question: how do i automatically copy data from one google sheet to another?
Answer: On your computer, go to docs.google.com/spreadsheets/.
Open or create a sheet.
Select a cell.
Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1! A1 or ='Sheet number two'! B4 .