Attached is the method I commonly use, a parameter with a calculated filed, a filter on the calculated field for each worksheet, and use a layout container on the dashboard so based on the user's selection the desired worksheet is shown.
There are some interesting things going on in addition, and I can offer options for some situations. you can see my comment at http://www.alansmitheepresents.org/2011/03/changing-viz-types-with-dashboard.html
For things that seem to be "falling down", like legends, you can create another worksheet(s) to act as a legend that is more controllable. So if you run into a situation like this, or have additional questions there are options, and I can provide additional details as needed.
My biggest issue with this method is the wasted pixels that the collapsed sheets occupy.
See The specified item was not found. for details on how to make this kind of dashboard.
Nice technique Joe. Thanks for the example and the various links. I take your point about the wasted space. This I think I could live with but for me the 'jumping' screen as you move between parameter values is more annoying. A nice workaround regardless.
On a side point, is there an easy way to unhide a group of hidden worksheets? You can multi-select them when you want to hide them but it seems to be a one by one approach to unhiding. It's only a problem when you are going back to edit workbooks with a large number of worksheets in them. I guess I'm looking for an overall view management control.
I agree, the "jumping" seen while in Desktop or Reader is not ideal, but when published to Server or Public, and when viewed in a browser, it is a smoother view transition.
As for hiding and unhiding worksheets that are in use on a dashboard, this is not new http://www.tableausoftware.com/support/forum/topic/unhide-all-sheets and I would recommend talking to your account representative to request a feature like this. Another option is Editing the XML, see http://www.tableausoftware.com/support/forum/topic/unhide-sheets-are-not-dashboard for some ideas.
I've consiously kept out of the XML so far. Maybe it's time to think again. Thanks once more.