enter image description here

I have a spreadsheet with 31 Day level sheets and a few summary sheets being used for a daily sales report, using which I’m trying to create a legder. For this, I want columns A, B and C from each of the sheets named Day 1, Day 2, Day 3 …. Day 31 to be arranged vertically, if the column A matches with any of the values from column E in the image shown (they are the customers).

This formula pulls value correctly from a single sheet – Day 1 here.
=query(‘Day 1’!A:C,”select A, B, C where A matches ‘”& textjoin(“|”,1,E2:E) &”‘”,0)

I want to stack the results from this formula for all 31 Days vertically, and group them by name, which is column A.
I tried using this formula below to see if this can work with 3 sheets, but it throws a value error: “Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A”
=query({‘Day 1′!A1:C237;’Day 2′!A1:C237;’Day 3’!A1:C237},”select * where A matches ‘”& textjoin(“|”,1,E2:E) &”‘”,0)

Can anyone help me resolve this, please?