How to turn hyperlinked sheet on and off, to compute data, or not

[kdrey]

I have 7 worksheet tabs all hyperlinked together to compute sums on each one for different reasons. One of the tabs is a Dr's information...number of cases, revenue, COGS, etc. I've hyperlinked it to the P&L sheets and Volume sheets for each month. Now I was asked to make a link where we can turn that Dr's sheet on or off so that the forecast will show the sums with his numbers and without them. Is there a way that I can do this since the monthly totals are hyperlinked?

 

[FDibbins]

Not sure tat hyperlink is what you are doing here, but maybe just referencing, instead?

Can you show the formula you are using?