Best Practices for Employee HR Dashboards

Hi - I am trying to create a dashboard for each employee in our company that contains their personal HR data (such as time off balances). I've created several reports that I would like to share with each user on a dashboard. Normally, I would utilize the "current user" feature and create one report for each element, one dashboard, and distribute to everyone, but I cannot share the underlying sheets with everyone.

Is there a workaround here? So far I have toyed around with 1) duplicating every report x every employee (very time consuming, and a headache if changes are needed), 2) publishing the dashboard while reports utilize current user filters, but the current user feature doesn't seem to work once published 3) sharing dashboard under a view-only workshare, again current user filters don't seem to work.

Any ideas? Thank you!

Answers