I don't think there's a way to do this inside of Tableau, though you could create an HTML page with two containers with the top container frozen. Within each container, you can reference the workbook URL and specify ?:embed=yes and &:toolbar=off to perhaps simulate what you are trying to do.
If I understand it correct,
Worksheet_1 could be fixed on the dashboard and Worksheet_2 could be made floating.