Question: how to transfer data from one sheet to another in google sheets?
Answer: In Sheets, open a spreadsheet. In an empty cell, enter =IMPORTRANGE. In parenthesis, add the following specifications in quotation marks and separated by a comma: The URL of the spreadsheet in Sheets. ...  Press Enter. Click Allow access to connect the two spreadsheets.