I have a list of 20 Names to filter in a list.

If I select one of the names, I would like the name to appear in a cell at
the top of the page.

Also, If I choose more than one name or all of the names, then I would like
to it equal the words "Master List"

Any ideas on how to do this. (Excel 2007)

Thanks,!