Be aware: To be able to use ImportRange, you must are included to be a viewer or collaborator for the spreadsheet from which ImportRange is pulling the information. In any other case, you will get this error: "#REF! mistake: The requested spreadsheet vital, sheet title, or mobile selection wasn't located." https://hbr-case-study-analysis10513.answerblogs.com/37568283/hbs-case-study-help-an-overview