Please follow the below community chain to achieve your requirement.
Let me know if this helps.
If you want the drop down from one dashboard to another dashboard/sheet follow the steps:
1. Go to dashboard select actions then click filter action.
2. After selecting the filter then select the sheet or dashboard which you want to move to that sheet / dashboard.
3. Then select ok.