So in tables on Sheet2 to Sheet7, there was more than a single formula per column? I'd advice to avoid this unless on those sheet were not tables, but reports. But then why did you have links to different language entries from Tab1 in those reports?

The only design I had where I used a dictionary table in my Excel projects, was an Excel app, where all data entry was made in main language (English), and user could select a reporting language. Report get data from data entry tables, and generated a report fully in selected language (the app was used in factories in several countries). Obviously this is not the case for your workbook, and currently I can see no reason you did need it at all.

This is not correct, maybe I explained not well.
The File I'm talking about is a form to be filled by suppliers globally with different Tabs for different topics (General Info, Concerns, Process descriptions, etc.). So each Tab (=Page) has already same headers and similar footers where you can find words like:
"Name", "Address", "Pls. sign here", and lots of individual information and questions which will be shown in different languages.
Depending on the laguage selected all Pages (Tabs) will occur in that language.
Now I reduced the amount of Pages and thus several words/sentences of Translation Tab 1 are obsolete. Those I want to remove, but without any risk to destroy the existing Pages or leave cells empty.
I hope this is more clear now.