If you have been using Google Sheets for awhile, you have probably ran across the desire to pull data from one sheet into another. This can be done using a couple of different functions like importrange and arrayformula.
Using these two functions, you can successfully pull data from one spreadsheet to another. This data doesn't even have to be static. You can for instance import Google Form results on an ongoing basis.
The article linked below provides a great overview of these to functions and some possible use cases.