I have a workbook with several sheets that has a pivot table per sheet. The
pivot tables access a sql database. The data is filtered on the period. The
filter is hardcoded into Microsoft query. All the pivot tables uses the same
filter, but very disparate data.

Is there any way that I can use a variable in the query that references
cells in the workbook?