Hi Krishna. Can you attach a packaged workbook? I think this is a workable solution by using a combination of containers and filters and actions. Basically, based on the selection in worksheet A, you can set the filter conditions to true in worksheets 1,2,3 and false in worksheets 4,5,6 (via actions). And do the opposite when the selection is clicked off.
Thank you for the response but I couldn't share my workbook because of the security issues.
Is there any other way in which you can solve this problem.
Thankyou Amit. This worked perfectly for my situation.