Coupler.io pulls data from various apps (Google Sheets, Xero, etc.) to Google Sheets and automates data import on schedule.
Install Coupler.io (https://bit.ly/2XWzcWW) from the G Suite Marketplace.

In this video tutorial, you’ll learn how to set up a Google Sheets importer in Coupler.io. It’s an integration to reference other spreadsheets. Unlike IMPORTRANGE, Google Sheets importer allows you to automate data import and combine multiple sheets into one sheet without any coding. To learn more about the add-on and available integrations, visit the Coupler.io homepage: https://bit.ly/3eHpcqx

Check out the related blog post:
How to Link Data Between Multiple Spreadsheets https://bit.ly/2S1HngU
QUERY + IMPORTRANGE in Google Sheets https://bit.ly/3eM0Ax5