How to insert in excel the number of mentions of a word from another excel?

Question

Visual Basic

Here is an excel.
There are several sources.
In general, everything is something like this:

Manually done without problems, but this is not our method, right?
I want:
when starting data exchange (well, or a macro), the number of mentions of a certain word is counted and displayed in a new cell with a date.
I did it with a request, but the garbage is that I get each result in a new sheet, but I don’t need it.

Answer 1

True, the method is not ours. Therefore, we create a macro that will open the xls file, find repetitions in it and write the result. If you are familiar with macros, it is easy to find examples for each of the subtasks. If not, then order a macro from a freelancer