How to have spreadsheet auto-populate data from Query each day without deleting previous day

[Hmill]

I connected an sql database that tracks how many work orders are completed in each lab each day to my excel file. I wrote a formula that index matches the data from the query to the spreadsheet but every time the day changes it deletes the previous day. How can I fix this?

This is the query and it updates each day. It only shows the work orders from that day.

This is my spreadsheet and formula.

 

[GraH]

Self reference the query. Buffer it. Then append it.
I answered a similar thread not so long ago.
The technique is explained in this video