This video demonstrates how to use IMPORTRANGE Function in Google Sheets. You can import data from other spreadsheets. Thsi is Google Sheets alternative to referring to data in other files in Excel.

Sales Data
https://docs.google.com/spreadsheets/d/1tSapEb63l53nZjG7suCKuZciTsafP7FA3pSG4aMAEgI/edit?usp=sharing

IMPORTRANGE
https://docs.google.com/spreadsheets/d/1K5J_M8gFBvpyuWHIo4-_jhlGciZjfcchLuBy6CNpIIk/edit?usp=sharing

Google Sheets
https://www.google.com/sheets/about/