Weekly Roster Project Tracking

Hello - We are attempting to create a table that allows us to track the projects that over 100 people are on a weekly basis. Given that a person can switch a project each week, we are looking for a simple way to select the project each person is on each week. The roster also changes weekly with new hires. Has anyone had success building something like this?

Rows: People, Start Date, manager
Column Header: Week
Column Values: Drop Down Project Option