Query all Google Sheets data from Google Drive?

Question

How can I query all Dates from all Google Sheets in my Google Drive? As far as I know, I can do multiple query for all the sheets using importrange, however, I have over 100 Google Sheets:

={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)}

Does anyone have a better solution?