In this video tutorial, I will show you how to link data in Google Sheets. I will go over linking cells and ranges on the same sheet in Google Sheets. Also, I will show you how to link sheets or tabs within a spreadsheet and how you can link spreadsheets to each other using Google Sheets. The two functions that will get used in this video are ARRAYFORMULA and IMPORTRANGE. 0:00 Introduction 1:25 Linking Cells in Google Sheets 3:49 Linking Ranges in Google Sheets 6:33 Linking separate spreadsheets in Google Sheets Here’s the link with all of the Google Spreadsheets after you open them make a copy of them under file: