Update Excel query value from Sheet

Hi everyone!

I connected one Workbook to a database to Microsoft query. So far so good.

My problem is that that query uses dates to sort the data and I wanted to have Microsoft Query fetch the value for the date in a Sheet on the workbook.

Meaning that in the CRITERIA FIELD I would have something like:

DATE
Cells(AA1)

Is this even possible?? I've attached a photo to help illustrate my problem.

Thanks in advance