Hello all,

I have a workbook of 40+ sheets and one query that aggregates the data from 30 of those sheets. I then have several queries that references that first query. However the first query is dependent on several sheets to remain hidden and no other sheets added. I already have modules that hides the sheets that need to be hidden and deletes any sheets not matching a hard-coded array of sheets.

Is there a method to call the 2 modules mentioned first before the query data refresh? I am trying to prevent the first query from aggregating unnecessary sheets if they forget to re-hide certain sheets or delete sheets when they are done. This scenario is rare, but on a few occasions it's happened, it has caused some egregious errors in supporting work and I would like to avoid the backtracking.

Thank you!