make a running list

have a spreadsheet with 30 worksheets that will be updated. in columns g,i,k,m,o there will be text put in for results found.

i am trying to put together a list of all the different results found and the frequency of said results.

example:
column
g = mouse, horse
i = horse, cow
k = moose
m = chicken
o = the devil

so this list would accomplish:

mouse 1
horse 2
cow 1
moose 1
chicken 1
the devil 1

any ideas on where to begin with this?

In case you have a list of all possible entries, put them on a sheet and then look at the CountIF function.
There you put in your range with where the results are stored and the criteria (mouse, horse ...). I haven't tried it but I guess you could define one range with all your sheets.
When you do not have the list you will have to generate it first. You can google the topic "Remove Duplicates" or come back - best with an example book.

Richard