Hello! Employees are sending me status of all the project they're working on, and I'd like to summarize all the info in one sheet. They send me:
- project department
- project title
- estimated completion date
Each employee is working on 1-6 projects at a time. Ultimately, this workbook will be stored on a shared drive where everyone can update their tab, and ta-da, the summary tab updates automatically!

How do I summarize this info:
- with no blanks between employee rows (Joe may be working on 2 projects, Bill may be working on 6, and this can change over time
- visualizing the completion date of each project, kinda like a gantt chart

Any help is appreciated!!!!
DB