I suspect these category names may contain a single quote ', and that’s causing the parsing error.
For example, a category name:
John's spending
If so, try removing the single quote, something like:
John spending
And remember to make that change on the all the sheets it occurs, likely:
Transactions, Categories, AutoCat
The QUERY formula typically uses single quotes as a string delimiter, like:
Col4 = '"& B6 &"'
and so that’s why they could break parsing.
Another option is to modify the QUERY formula, instead, and replace each single-quote ' with two double-quotes "" - it takes two double-quotes to make one double-quote within the larger QUERY string that uses double-quotes as it’s string delimiter. Then the cell reference string delimiter will be double quotes and categories containing single quotes will work.
Col4 = """& B6 &"""
Using single quotes for sub-strings within the QUERY formula is easier to read and more common, though, and so it’s possible to run into the issue again with some other solution that uses them, if the category names contain them. Generally, the fewer non-alphanumeric characters in your data the better 