How do you catalog every value or word from every cell in alphanumeric
order with the number of respective repetitions?

Ex. If every cell in a range contains a description of various
scientific results in sentence form, the goal would be to list all
words and values found as discrete elements (separated by spaces) and
to list the number of times each was found in adjacent cells. The
purpose for this application would be to find keywords and flag their
associated records (rows).