Copying cells dynamically to a worksheet based on values in another worksheet

I have 3 worksheets, one each for the first 3 days of the week. Each day has a unique menu. Users use dropdown lists from the Values worksheet to make selections. Their selections get a score of 1-4 that I pull using VLOOKUP; 1 is healthy, 4 is not. Each unhealthy choice with a score >2 has warning instructions. Once all the menu selections have been made, I would like to generate, on a Report worksheet, a list of only their unhealthy choices, ordered by Day, along with the warning instructions for each in the same row. Healthy choices should not be on the report. Below that, I would like to print out further warnings based on a set of rules that span across days. This report identifies combinations of bad choices in a week. The sampleMenuBook.xlsx xls I created only has 3 days, and only a few choices, but you can imagine a real one with 7 daily worksheets and a much bigger menu choice. I don't know how to create the Report worksheet. Would appreciate any guidance you can provide. Thanks.
freelance

TehneXus, you rock. It did exactly what I expected. The Report page got repopulated with the right data. Interesting, the report started with the first empty cell. That's what I wanted, but didn't think about the case where there was already a report on the page. Is there a way to get the report to start on a particular cell, let's say A2 no matter what data is already there? I would like to overwrite the data as menu choices change. This is a really robust script. It told me all the days that were missing from my worksheet. It'll take me a while to fully understand it, but I get the basic concepts you used. Thanks, the folks at the retirement home will be ever so grateful.

TehneXus, you rock. It did exactly what I expected. The Report page got repopulated with the right data. Interesting, the report started with the first empty cell. That's what I wanted, but didn't think about the case where there was already a report on the page. Is there a way to get the report to start on a particular cell, let's say A2 no matter what data is already there? I would like to overwrite the data as menu choices change. This is a really robust script. It told me all the days that were missing from my worksheet. It'll take me a while to fully understand it, but I get the basic concepts you used. Thanks, the folks at the retirement home will be ever so grateful.