Individual task lists for unlicensed users

Hello, can an unlicensed user see a list of all tasks assigned to them (across different sheets)? Our resources are frequently unlicensed as they only have to view the tasks, so they can't create reports.

I guess the project managers could create reports for individual resources, but the problem is that not all departments in our Company use the same shared workspace - but we do share resources! So a single project manager couldn't run a full report because they wouldn't necessarily have access to all sheets where that individual is resourced to.

Basically, reports seem to be the usual go-to to create list of all tasks, but in our case I'm not sure they are very useful. Is there any other way for someone to see all of the tasks they've  been assigned to?

Thank you!