Our projects are sub-sites of the parent PMO site and each of these sub-sites has a project task list that is used to assign tasks to users.
Is it possible to roll up the tasks from each task list to a central list on the main PMO site so that a report can be produced showing the status of all tasks? We can currently produce a report for each sub-site's task list but we then manually consolidate them, I would like to move away from the manual consolidation.