Google Sheets Query with Importrange
Data File: https://docs.google.com/spreadsheets/...
Summary File (contains query function): https://docs.google.com/spreadsheets/...
Financial models: https://www.smarthelping.com
Query a range from another workbook with multiple unique identifiers and returning multiple columns on a new workbook. This has a ton of useful application. Enjoy!