What can replace the importange formula to transfer data from other tables?

Question

Google Sheets

In Google Sheets, the importange formula is very often used, because of this, the table hangs very much. The table is pivotal and displays results from 11 other tables. Is it possible to replace the formula with something or lighten the table, since it is no longer possible to work in it.

Answer 1

• The simplest option is IMPORTRANGE . Data is synced automatically
  
• A more complicated option is a script based on Spreadsheetapp. OpenById
  
• Even more complicated, but, in my opinion, the fastest way is a script based on the Sheets API