So Tab2 to Tab7 were data entry sheets. User selected the language he/she did want to use, and headers on data entry sheets were displayed accordingly. The info entered into those sheets by user was not translated later anywhere. And no only Tab4 and Tab7 of them remained (and were redesigned).
And on sheet Tab1 is a table with some number of columns with text in different languages.

It looks like the solution I adviced in Post#2 may be work for you, but instead 2 of them you must have 2*n (n is the number of available languages) additional columns in Tab1 - 1 for every language per Tab4 and per Tab7

Update: Probably you can do it with 2 temporary columns only - you simply select a language, and then search for matches in selected language.