excel project - macro tasks need amending 8

Hi

I will need to go back and rename some 100 or so spreadsheets where it says "Legal structure" for row #16 to "Umbrella fund legal structure".  It's quite possible that I might need to also replace names because I have several different fund type templates, I need to harmonise them.

Is there a quick and dirty macro that can be developed in a new worksheet called "Data maintence" which will allow me to undertake such data maintence tasks of replacing one word with another in range of spreadsheets (using either the range set on the summary worksheet or using a new range on this "data maintence worksheet"?

I will need to start harmonising a lot of different templates and by using the "Criteria selection" worksheet list, this will help me enormously.
summary-macro-test.xls