I have a range of cells with too many words in rows and columns. I want to find how many times a particular "Word Phrase" is repeated in the entire range of cells.

For example:
Cell ranging from A1 to A200 have an average of 25 words in each cell.
Now, I have a list of phrase eg. 'Awesome In Excel', 'I recomment Chandoo', 'Chandoo Forum', 'Learn Excel' and so on. I want to find the number of times each of this word is been used from the entire range i.e A1 to A200.

Thanks in advance for your answers!

Regards,
Faiz