Is it possible to populate table row labels (the first column) from a named range of data?

I have a sheet intended to capture results and then produce MI on the results. A series of questions have either drop-down lists or free-format entry answer cells. The drop-downs are populated with list data validation from a named range.

What I would like to do is generate a table showing the values of a named range in the first column and the count of the occurance of this value in the second.

I currently simply copy the values and generate the table manually but it would be nice to be able to add values to the named range and have the table (and charts produced from it) update as well.

I appreciate this may be possible with pivot tables and I could probably build a macro to do it however I wondered if there was any such functionality available already (possibly using external data features of which I know next to nothing).

Any help appreciated.