Fill Multilingual Excel Compilation

I have a six-sheet Excel workbook, each sheet representing a “book”. Sheets 1-5 are complete in five languages (columns A-E), while Sheet 6 is a curated compilation that currently holds only the first three languages (columns A-C). I now need columns D and E on Sheet 6 populated automatically.

Here is the exact logic I need captured in a macro, Power Query step, or any other repeatable approach you prefer:

• For every row in Sheet 6, take the value in the first-language column (column A).
• Search Sheets 1-5 for an exact, case-sensitive match of that text in their own column A.
• When a match is found, copy the corresponding values from columns D and E (languages 4 & 5) into the same columns on Sheet 6.
• If the match appears in multiple source sheets, the first exact match encountered is sufficient.
• All original cell formats—fonts, colours, and any data validation—must be preserved in the pasted results.

Please keep the solution compact, clearly commented, and deliver back the updated workbook plus the underlying code or query so I can rerun it whenever the source sheets change.