I am kind of a new with excel and i have been assigned to do some work in xml files.I load them from excel,they are listed in categories.So my task is to write a script that i can get all the categories and number of duplicates in every sheet and write them to a new sheet.For example

Original xml:
Hotel
nails
Beauty/hair
Hotel
nails

The sheet that i have to create vis script must be:
Hotels 2
nails 2
Beayty/hair 1

Any help would be really apreciated