Query all google sheets data from google drive?


Good morning,

I have a concern and could not find anywhere online.
How can I query all date from all google sheets from my drive?
As I know, i can do multiple query all the sheet with importrange, however, i have like 100 sheets or more. Do anyone have better solution ?

={query(importrange(“URL”,”‘TX’!A:U”), “Select * where Col4 contains ‘”&D2&”‘”, 0),query(importrange(“URL”,”‘TX’!A:U”), “Select * where Col4 contains ‘”&D2&”‘”, 0),query(importrange(“URL”,”‘TX’!A:U”), “Select * where Col4 contains ‘”&D2&”‘”, 0),query(importrange(“URL”,”‘TX’!A:U”), “Select * where Col4 contains ‘”&D2&”‘”, 0),query(importrange(“URL”,”‘TX’!A:U”), “Select * where Col4 contains ‘”&D2&”‘”, 0)}

Thank in advance.