Connecting two Google Sheets with the IMPORTRANGE function can be hugely beneficial when you need to collate data across multiple sheets