The secondary navigation will be vertical instead of horizontal but this is the closest thing to what you have described that I’ve seen.
Other than that, I think the best way is still to create your own primary navigation in your application and embedded one dashboard in each tab. The sheets in your dashboard will then be your secondary navigation.