Excel Multilingual Sync Automation

I keep a master Excel sheet in English and rely on Excel’s built-in Translator to create 25 separate language files. My workflow breaks down whenever I edit the English version—especially when I apply new formats or reorganise the entire sheet—because the changes do not cascade to the translated copies.

What I need is a single, central database-style workbook that will:
• detect any update I make to the English sheet (I often revise the whole sheet, not just a few cells)
• run Excel Translator in the background to refresh all 25 language sheets instantly
• paste the translated output as pure values so my software reads clean cell contents, never formulas
• replicate every formatting tweak exactly across all languages, preserving fonts, colours, merged cells, column widths, etc.

Please build this only with Excel tools—VBA, Power Query, dynamic arrays, or any reliable method that ships inside Office—so there are no external dependencies.

Deliverables
1. Master workbook containing:
– English source sheet (editable)
– 25 auto-updated language sheets, each holding static text values
2. Well-commented code/macros and a short “how-to” note so my team can maintain or extend it.

Acceptance criteria
• I edit the English sheet, press a single trigger (button or Worksheet_Change), and all translated sheets update within the same file.
• No formulas remain in the translated sheets—only values.
• Visual layout, styles, and cell references mirror the English original perfectly.

That’s the entire scope; once this is running smoothly inside Excel, the project is complete.