Contracts to spreadsheet> spreadsheet to letters

I’m rapidly learning how to use Excel to speed up my work in commercial and pricing, but I’m aware there are vast gaps in my knowledge. My task next wk- record current prices for all products (about 10) in around 50 contracts. Apply various increases (or not) depending on contract clauses. Propose pricing and effective dates in separate letters to each with a specific table in each letter. How would you optimise this task and automate as much as possible? I have thoughts (and Chat GPT) but interested in how others would approach, and in parts of excel (eg mail merging into word) I have never used before