I have one spreadsheet that contains 6 or 7 Queries that are all directed
toward the same data source "MB7 data - 2006". These were needed to pull
figures from last year's data. But I now need to point this entire sheet (and
all of the queries) in the direction of this year's data..."MB7 data". Is
there any way to redirect these queries toward a different data source or
maybe copy them into a new query that points towards the current year's data?