Excel Tables

Thanks in advance for your help!

I'm trying to create semi-dynamic tables, but I'm having a bit of trouble getting the data to update and filter properly. Basically I have one data table that has names (John, Jane, etc.) in one column and their favorite color (red, blue, etc.) in another. Now, this table is updated fairly regularly, and I want any linked tables to update their size, formatting, and data whenever a new entry is added to this table.

The first analysis table I want to create is a list of all of the names, which on its own is easy enough, but again making it update is proving difficult.

The second table is harder. I want to create a table that lists the names of only the people whose favorite color is red, but I'm not sure how to go about this. Using a Pivot table hasn't worked so far.

Any advice would be appreciated.