Trying to count a range of multiple words in a spreadsheet

I have no idea if this can be done or not so hoping someone can show me how to do it or tell me it simply can't be done.

I have attached a sample workbook to help explain what I am looking for - if there is an easy way to do this could someone please add the formula to the sheet for me?

If you can imagine something like an Argos catalogue and the amount of product descriptions in that I am trying to figure a way to include common words to help customers identify the page number the product is on.

I figure one way would be to identify words found on most product titles to help identify which words to include in the index.

So on the attachment yo will see I am hoping for a formula that can count and list all the various words that are included in a column. I know I could do somethign similar if I swas wanting to count the number of times a single word appeasrs but unsure how to do it for everything listed?

Any thoughts/suggestions/answers would be greatly appreciated.

Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20158) 64-bit

Thanks Ali - it half helps - I need a way to show the full list of individual words too (I literally just typed in the individual words into column E based on what I could see in column B) so need a way to add this list for it to be able to lookup as per your formula? I'll update my profile shortly

Never heard of a powerquery - (I only do basic excel as you can probably tell lol) - will see if I can figure out how to do that thanks