Publishing Report to Multiple People

I have read many articles and threads on this forum that are similar but haven't found a concrete answer, unless its just not an option...

I have reports tailored to different departments that I want to share with select people. I want the President to have access to ALL reports, and then people in specific departments to only have access to their reports. Right now I have different workspaces for each department (some for individuals too if they only have access to one of the reports for a given department). There is a lot of overlap in doing this and I have the same report in multiple workspaces. This is annoying because if I change something or refresh anything I have to republish the report in all workspaces instead of just once. If I create dashboards for each report and just share those with select people, it makes things easier, but I want all users to have access to the datasets to create their own reports, which they cannot do from just having access to the dashboard (unless I am missing something). If I create a content pack and share that with everyone, they have access to the dataset, but when they create a new report it just makes a copy of the original dataset. So now when the dataset is refreshed, their custom report won't be updated as it is using a copy of the original data, correct? Seems like there should be a way to upload the reports and just share each individual report with multiple users so they can access it.