Find all AND Select all that is found

I have created a spreadsheet that populates a specific template a certain number of times and then copies data from a huge data sheet into that template and sorts it. The template fits exactly on one page when it is printed, and on the template there is a place to indicate the "Revision" of the document. This has to be updated every time that any changes are made and it has always been done manually. I would like to write code to do this, and this is what I would like to do:

Find all the cells with the word "Revision" in and select all these cells. Then it must offset the selection by one column, because the actual revision number is in the cell to the right of the word "Revision". Then it must then give an input box asking the user to type the new revision number and the code must then update all the selected cells at once. I have tried to record a macro to find the code for the built-in "find all" function, but it doesn't record anything. And I have also not found an appropriate solution by googling it either. Can someone please help?

Attached is an example of what the workbook looks like. I only made two tabs and a few templates on each to simplify it, but the real worksheet has lots of templates on each sheet and a few more worksheets. It has to be viewed in page layout view.