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.