Provide a sample workbook. I can help.
You can use a principle similar to swapping. One will always be displayed in the container, but the other will display only if B and/or C.
The trick will be creating a calc that detects whether or not "A" has been selected (or whatever specific conditions you want to use to hide/show the extra sheet.)
So its something like this where I have worksheet 1 2 3 4 (w1,w2,w3,w4) and I use filter to relevant values. So when the filter shows say either b or c, then it resizes the w3 pushes it to the left and w4 appears.
While the filter shows just a then w3 takes up the entire space.
PS: Excuse my handwriting please
I'll need a workbook to play with.