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.