Automatically moving specific rows to new sheet/omitting columns/combining data

[milChuck]

I think I might be approaching the length of my ability. I have been creating a workbook to track the readiness of our employees to travel to other locations. Each employee has to accomplish about 30-40 items to complete thier pre-travel requirements.

Attached is an example of what I am talking about. Our actual spreadsheet has about 80 names (about 3-20 are added or removed each week), and my superiors are asking me for a product which can, at minimum, be used to report to their superiors.

Sheet 1 is the full list of people and items in the table.
Sheet 2 is a blank table of what needs to be shown and an example of exactly what should automatically populate inside the table.

Thanks for checking it out.

[Charlie_Howell]

is this what you need ?