List all unique values from multiple sheets in specified column

Hi all,

I am looking for a way to list all unique entries from for e.g. row b over all sheets in my workbook.

The idea however is to have this continually updating and everytime a new unique value us added into the row it will automatically appear.

This is going to be coupled with COUNTIF to feedabck the number of times used.

Thanks,

Ben.

Can you please post a sample workbook so that its easier to understand the problem?