0

I want to view other spreadsheets data with cell function in Google spreadsheet

IMPORTRANGE cell function is awesome but, it required to know sheet name

so question is how can I get other sheet data with cell function without sheet name

:::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::

Data sheet has four sheet,

1st sheet name is SN1

2nd sheet name is SN2

3rd sheet name is SN3

4th sheet name is SN4

:::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::

Location in script editor

1st sheet location number is 0

2nd sheet location number is 1

3rd sheet location number is 2

4th sheet location number is 3

In Google script, I used to location number when I need to change many different specific cell data from specific sheet even I don't know sheet names

:::::::::::::::::::::::::::::::::: ::::::::::::::::::::::::::::::::::

It is quite easy to get data when I know the sheet name IMPORTRANGE("URL", "sheetname!A1:D21")

but, how can I get other sheet data with cell function when if I don't know sheet name.

2