If you have worked in Excel and you got to a more advanced level, you probably found the import features, MS Query and ODBC very usefull. If you since moved to Google Sheets you probably looked for an alternative to get information from one sheet / document to another.
Look no more, this is what the import range function in Google Sheets does. A demo in the video bellow, part of the Google Sheets Beginner Intermediate training that I have on Udemy. Grab a discount code here: https://www.udemy.com/google-sheets-beginner-intermediate-training/?couponCode=%23off15