Is there a way to make this query formula work? it was working before but I had to add more sheets and then it broke

Question

Formula that combines all the sheets in my project and removes any empty cells

Answer 1

yes, change this:

;},

to this:

},