What about just having links on the dashboard to each of the selected sheets for a url to csv download the view. I think the best solution is the one offered here though - The Greatest Tableau Tip EVER: Exporting Made Simple! - set the image on the dashboard to link to the csv output for that view.
I hope that helps.
Please mark this post 'correct' if it answers the question best for you.