How to query data from other sheets and IMPORTRANGE
Exp:
=QUERY({IMPORTRANGE(A2,"DATAOUTBOUD")},"select * where Col1<>'' Order by Col12 DESC ",0)
We have 4 sheets
-sheets1
-sheets2
-sheets3
-sheets4
=> All sheets -> sheets1 -> sheets2 -> sheets3 -> sheets4