I am trying to compile a list of lunch orders for my company using the below format and I would like to have summary sheet that reflects who ordered what for lunch on each day for easy reference.

I have a separate sheet from Monday through Saturday where I record their orders and it looks something like this:

Chicken Noodles Fried Rice w/ Beef Fried Rice w/ Egg Fried Chicken Fried Noodles Pizza Lunchbox 1 Lunchbox 2 Total Price per Person
Price 30,000 25,000 25,000 40,000 25,000 20,000 35,000 30,000
Name Job Title
Alpha CEO 1 1 60,000
Bravo COO 2 60,000
Charlie CFO 1 30,000
Delta GM 1 20,000
Echo Senior Manager 1 1 60,000
Foxtrot Manager 2 70,000
Golf Executive 1 25,000

Thus, what I want to achieve here is another summary sheet which allows to me know who's eating what on each day to allow for easier food distribution. I have no issues if any individual only orders 1 set per day but as it turns out, some are gluttons and would have 2 or more sets (could be either same or different) a day.

If I'm being unclear here, please let me know and I will clarify further.

I would really appreciate any solutions to this and I apologize for the lousy formatting of the table lol.