How to automate text processing (deleting/replacing phrases)?

Question

Automation

It is necessary to automate the text processing task:
1) deletion of the specified words/phrases
2) replacement of the specified words/phrases (what is indicated for what to change)

Removal and replacement should be based on dictionaries (dictionaries for deleting words and dictionaries for replacing words). For example:
1) Dictionary "Question words" - should DELETE all specified question words from the text
2) Dictionary "Devices and technologies" - should REPLACE all specified words with the specified pair. For example: macbook / macbook / mac book - macbook.

Ideally: clicked the button and got the processed text based on the list of delete/replace dictionaries. At the same time, it should be possible to add new dictionaries and add / edit existing ones.
Who will tell you how this can be done? In what environment it is better to implement it?

Answer 1

1) Record "find and replace" with a macro recorder
2) Make a separate sheet with settings
3) Loop through the data from 2) , execute macro 1)