Obtain data from a cell with lots of paragraphs

Cool, So I have multiple questions I need help with regarding formulas and macros.

ok, So I have a cell that contains paragraphs of text. Imagine I'm a teacher, and each student gave multiple paragraphs of text. Column A has the student's name, column B has the text.

(Row 1 is title/headers ofc)

Ok, now everything regarding column B.

1. Need the formula to find a specific word in the cell, provide it True/False if found. (in column C).

2. Then, how many times that specific word in the cell was found. (eg, how many times the word "the" was in the cell". (count of matches in Column D) (this can be dynamic, eg, Change a lookup cell with words, or a range of cells to lookup. like, finding the word "all" "therefore" "the" "hence" and give a total count or individual count of it all.

3. Super hard? So now imagine the paragraph is a theater script. with what the person says is followed by ":"

(eg, John: howdy partner!" Lisa: g'day Aaron: Hello y'all everyone John: Hello y'all, nice to meet everyone finally)

Here, I'll have a cell (or range of cells like in (2.)) to look up. Say this word is "Hello".

And I want the output to be the sentence/utterance that preceded it till the match on ":". With its multiple matches.

Thus the output of this formula would search the keyword "Hello y'all" (case insensitive) and provide the output.

g'day

Hello y'all everyone

(these are separated by a newline/enter key)(or separated by commas, cause I can use "find and replace" to change all commas to newline anyways)(in the same cell)

same cell output cause I have multiple students and I need it for each student individually, and there are 500-1000 students usually in the workbook, a new batch of students every day.

4. Finally, If possible, a macro to quickly do all this, but the output is on a neat and clean new sheet.