What you need to know about the IMPORTRANGE function
Google Sheets – Import Data from Another Spreadsheet – Tutorial Part 1
Of all the G Suite web applications, Google Sheets is perhaps the most impressive. Released in 2006, it quickly became a formidable competitor to Microsoft Excel as an emerging spreadsheet editor.
Today, Google Spreadsheets includes a wealth of editing and collaboration features used every day by millions of students, workers, and hobbyists.
One of the most valued features of Google Sheets is its robust set of functions. Functions are a core component of what makes spreadsheets so powerful, and each spreadsheet editing platform typically has several of its own unique features.