Automating Find & Replace

I have a multi-sheet workbook that I use as a template for projects. A lot of the data is redundant, like a company's name or the project name, and it is inserted multiple times within the workbook. So to make it easy I thought of using a find/replace function. For example, when the document contains <project> it will replace it with the 'project name'. Then I decided to make a "KEY" which I call "code sheet" in the workbook that I use to enter in data then proceed to use the Find/Replace function to update the entire workbook based on the entry.

However, while I thought this was smart in practice it feels even more redundant and time consuming because I have to copy/paste > find/replace each entry (column B) after i get done typing it in the 'code sheet'. I'd like to have it just do it on its own by referencing the code (column A) with whatever I type in the corresponding (column B).

Problem is, I have ZERO knowledge of Macros or VB scripts. I don't even know where to start. Some direction would be much appreciated!