Copy items from dropdown list to new sheets

Hi John

sorry have had one of those days and head not working properly.

First , for Clients use your original formula

=TOP!A6 and copy down
If my clients start at =TOP!A4 will I use that instead?

For Juice, Dessert, Main Meals (in TOP) for Monday

=VLOOKUP($A6,TOP!$A$4:$O$29,3,0)

=VLOOKUP($A6,TOP!$A$4:$O$29,7,0)

=VLOOKUP($A6,TOP!$A$4:$O$29,6,0) I have placed this formula in cell for TOP Tab in worksheet. How do I get the 2 choices of meals for Monday Roast Beef and Chicken Pie to show up in the correct column in the 'MON VOLUNTEER'S' tab. When I select beef in drop down list from TOP tab under Monday, I need it to show up in the beef column in the 'Mon Volunteers' tab. When I select the Chicken Pie from same drop down list I need it to show up in the chicken pie column in 'Mon Volunteers' tab. I then need the total of beef and chicken meals for clients to total at top of each column for each meal choice.

sorry just want to make sure I put it in the correct cell and dont make a mess of it all