VBA to modify SQL Query inside of Access

Good afternoon everyone,

I am having trouble finding a solution to the current problem I am having. I have an Excel workbook "Weekly Metrics Admin Tool" that has two buttons. The first button opens a database that houses a bunch of queries that generate the weekly metrics reports. However, when I click it, it targets ALL the data in the tables and not just last week, what I am reporting on. I know I can go in and use a LIKE "Week 49", but I do not want to have to change it every week.

My initial thought is to have a cell in the workbook with the admin buttons where I can quickly enter the week I want it too target but I need help with the VBA to have it reference that cell and modify the query!

Any help would be greatly appreciated!

The macro opens the Access database and runs the query inside of there.