Create a 'New List' based on specific criteria

[Steverino]

Greetings Excel Guru's,

Clients	C	B	R	A	Car	Bus	Rail	Air
John Public	X				John Public
Jane Doe	X		X		Jane Doe		Jane Doe
Mary Smith		X				Mary Smith
John Doe			X	X			John Doe	John Doe

<tbody>
</tbody>

Clients list is the master list of all names.
From that list, I need to create separate lists based on the criteria of which each client is applicable; I.e. If "C" then client appears Only in the "Car" column, likewise if "R" is checked... the client name will only appear in the "Rail" column.
I am only able to generate a list - based on 'Data Validation' at this time, which which I have to pick and choose each name.
= Is There a Way to generate or populate a new list based on the criteria of the columns (C,B,R, and A).

[Each of the new lists will be used in multiple other worksheets]

Thank you.
I have learned more about Excel from reading your answers, than I could ever imagined.

 

[Warship]

Are we populating a grid as shown?
Or creating new lists on seperate sheets? (VBA ok?)
Or both?

For the grid:
If the header "Clients" is in A1 then
in F2 put: =IF(B2="","",$A2) then
fill across to I2 then
fill down as needed.

 

[Steverino]

Thank you Warship.
I just had to make a small addition so I didn't get a 'true', 'false' response, but it worked fine.