Count of Past Due Tasks by Assigned Over Multiple Sheets

I have a few similar projects. I am running similar sheets for each of them. I want to create a separate sheet/report that shows me, across all projects, the total count of past due tasks by Assigned To person. I'm looking to create something like the attached image. The list of Assigned persons can change at any time on any of the tasks on the main project sheets. Some contacts may not be on all three projects. I would like to avoid having to manually maintain the "Assigned To" column on this new sheet/report. Is this possible?