Pull data from one of two related IMPORTRANGE Google sheets?

There are two related function IMPORTRANGE Google table
table 1 and table 2.
In table 2 the calculator with data entry
In table 1 performs all internal calculations, the results of which are shown in table 2.

For example, table 2 I have the access editor, how to get data from all sheets from table 1 ?
Which is configured the connection, but direct access to it.

If table 2 to make a new empty sheet, enter =IMPORTRANGE(code table; range) without the sheet name, I will automatically receive data on 1 sheet, but how to get the data of remaining sheets, if the sheets are not the standard "2 Sheet", "Sheet 3", etc.
April 19th 20 at 12:01
1 answer
April 19th 20 at 12:03
No way. You need to loop through the sheet names.

Find more questions by tags Google SheetsExcel