Drawing information from multiple worksheets to generate a summary report

Hi all,

I have been struggling with coming up with ideas on how to pull this off: I would like generate a project progress tracking report, which pulls information from multiple worksheets (where individuals record their tasks for different assignments). For example, by selecting a particular project from a dropdown menu in the tracking report (for example, if selecting Project1 in referring to the attached Sample Data file), all tasks recorded by everyone (i.e. among Name1, Name2, Name3 within the 3 worksheets) relating to Project1 will be listed in rows, along with who is working on this task, the Rec#, Input Date, Projects, Tasks, Priority, Task Progress, Upcoming DD, and Concluded (basically include all relevant columns for Projects). I would also love to have tasks listed in chronological order if possible. Unfortunately we need separate tracking sheets for each individual, otherwise we would simply all share a single "tracking report" for each project. The tricky thing is that not all entries are related to Projects (must be identified as "Projects" in the Workstream column).

I know this is asking a lot, not sure this is even remotely possible. Hopefully the above makes sense. Any suggestions or tips to lead me in the right direction would be appreciated.

Thank you kindly,
Kristin