Question: how to export data from one spreadsheet to another?
Answer: To start, open up the spreadsheet or tab you want to copy to the new Sheet > copy the sheet's URL.
Make a note of the cells you want to import.
Open the new sheet where you want the data to appear.
In the cell begin to type > =IMPORTRANGE (you'll see the code as you begin to type)