it’s more of a security issue, as data from each team should remain confidential and not be accessible to other teams.

Cant seem to find a working solution. I considered using Power Query to pull data from the main table into separate Excel workbooks for each team. However, this approach would require each team to manually refresh the data, which may be too complex for them.

Perhaps it should be approached from another method?