thanks for the quick response. Unfortunately not. It's a requirement that each click on one of these 6 boxes triggers an action that the related datasheet of the specific box appears
Place all the 6 detailed in the same container either horizontal or vertical
Pass the action from each cell sheet --> Run Action would be "Select" --> select the source sheet and target sheet --> select the clearing the section will be "Exclude all values"
If there is no dimension common between 6 sheets , then create a field with value and place in the both source sheets and target sheets in detail and pass the action on the selected fields --> select 1
This will solve your issue kindly mark this as helpful or correct so that it will be helpful to others
Hi Naveen, thanks for the reply. I think you are on the right path but unfortunately I am not able to implement it. I attached the workbook so you can see my issue. My 6 filter boxes are the small blue boxes and when I click on them the specific (blue colored sheet) needs to appear on the right. Can anyone help me? Thank you!