vba find unique names in multiple columns

Hello again, please for your help.

I have a sheet that have names is columns AH3:AS100, the previous and next columns have other numbers, names etc. In the previous range some names are written in more than one column. What i want is the following:

1. Create a list in a new sheet that have only unique names (remove duplicate)
2. count the unique names

Please for your help. I appreciate.

Yes it is what i want!!! 100%
Thank you, for the quick response!!!

Hello,
I tried this macro and didn't get any results. I am a novice so perhaps you can give me a more detailed description of what else needs to happen besides pasting this code into a module and having data in "AH3:AS100". In my situation, I'm trying to extract from a matrix of data all job names and hrs per job. Column A has employee names, Column B has Monday jobs, Column C has Monday hours, column D has Tuesday jobs, E has Tues hrs, etc. I want to list on sheet 2 of unique job names in 1 column and the hrs in an adjacent column. Thank you in advance for any help you can give me.