Imports a range of cells from a specified spreadsheet.

How To Use in Sheets

IMPORTRANGE(spreadsheet_url, range_string)

External Links

4Better Sheets Tutorials

Stick around after the 1st portion of the video for bonus content.
Covering some of the basics I skipped over in the part 1 video.
A funky way to password protect some data in a sheet, 3 ways to do it: with IF(), Apps Script, and Encoding


Quick intro to a better experience of using Google Sheets