You can achieve this using a parameter.
Also for header of worksheets these should be removed.
You can add a label using the parameter which can change on the parameter option selected and sheet shown.
Please let me know if you need further assistance on how to do this.
The header swapping i could achieve using parameter, Thank you.
I am facing the sheet swapping issue with action filter. I am trying to swap a single worksheet with 3 other worksheets. So whats happening is only one worksheet out of these 3 worksheet gets swapped and rest remains in the same place.
Please let me know if there is any sheet swapping procedure at container level.
Hi Anu do you have a sample workbook you can share.
I'm guessing if one of your sheets is being swapped it is probably a small fix to get the other 2 swap
Please share and I can look into this for you