Move data from one database to many sheets

I work in a retirement home and I am the chef. I am trying to make the weekly tally of there choices a tad bit easier and less time consuming.

I have made a workbook that contains a sheet with the whole weeks choices for everyone, then I have added sheets for everyday of the week.

What I am looking at doing, which I cant seem to figure out, is to have it automatically add the residents name to the weekly sheet.

The tab for sunday is what I would like to the look like. So as I add the number choices of 1, 2 or 3 to the weekly tab I would like it to take the choice of 1 and add there name to that day.

So on the sheet lets say Mike wants choice one for Lunch on Monday. When I enter the value of 1 I would like it to enter Mike under the Entree 1 collumn in the monday page, if I change his choice to 2 I would like it to automatically move his name to the entree 2 collumn.

I dont know if this can be done but it will save hours of work on my part.
Thanks Brice