1 of 1 people found this helpful
As Zhouyi mentioned you can use a parameter in a dashboard to select which sheet is shown.
But also using similar parameters I like to have 1 sheet that adjusts according to the selection.
Attached is example woorkbook of each using Superstore data.
Here is a link for step by step of the "sheet selector" style: