Thanks Don! Very interesting approach you took. I think that in my case it will work better for me to have multiple dashboards on their own tabs, since the layout will be different for each dashboard. I think I will still need to use just one workbook for all of my dashboards so they can all be connected when I publish them to the server.
I imagine my other option would be to publish all 6 dashboards from separate workbooks (since they don't use overlapping data), and then maybe make a dashboard that includes the links to the other published dashboards for easy navigation.
Thanks again for posting this- it is definitely a method I will consider for other stuff I am doing. Great to have such helpful people on the forum! All the best,