Macro to Translate Text from Lookup Table

Hi All

My problem is a relatively simple one, however I am new to Macro's and haven't programmed much since a VB course 15 years ago... o.O

I am trying to find the best solution to convert text from one language to another.

A conversion table exists in a separate worksheet, and I have already successfully implemented the VLOOKUP or alternatively the INDEX(MATCH) functions which offer a quick (and dirty) solution, however these functions come with limitations in user friendliness for future document revisions.

I am looking for help to create a macro that does a find and replace computation for about 1000 lines of text depending on language selection, with the ability to change back using the same lookup table.. I do not wish to use google translate as I require the translation to be 100% perfect based on the accuracy of the word list and I wish to keep the source document confidential.

I found a similar post to modify website addresses, but I do not know how to customise this (or if there is a better solution) to my scenario
http://www.excelforum.com/excel-gene...-a-string.html

I upload a test excel file with the scenario. languagemacro.xlsx The requirement is to replace the words in worksheet (main) using the table in sheet (text)
I have found some code to dynamically replace the names of the worksheets which I also need to incorporate into the final macro:

Sub RenameSheet()
Dim rs As Worksheet
For Each rs In Sheets
rs.Name = rs.Range("D1")
Next rs
End Sub

I have used a created language for neutrality. "dif tor heh smusma!" (Live long and prosper!). I hope I followed all the rules for posting, if not, please let me know.

Thank you
Grunberger

** 2014_10_23 edit: I have solved this, and will post for others once I clean up the code. Thanks. Until then, here's the link that led me to my goal :

HTML Code: 

I will change this to resolved accordingly.