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: https://drive.google.com/drive/folders/1oQC3QYdkyUqbs9Ixw_jzJs_z1MuGLUHu?usp=sharing