Question: how to import data from one google spreadsheet to another?
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.