Importing Data from One Spreadsheet in Google Docs to Another
Based on this post: . Learn how to import live data from one Google Doc to another spreadsheet in Google Sheets using the awesome IMPORTRANGE function. When you update the data in the original spreadsheet it will update automatically wherever you've imported it. And you can apply formatting to this data just as you would with a static spreadsheet. And you will look like a data badass. So there's that as well.