Automate Excel Financial Data Entry

I spend far too many hours manually re-typing financial figures from several Excel spreadsheets into our reporting application. I want that numeric input automated end-to-end so the values flow straight from the workbooks into the target fields without human intervention or copy-paste mistakes... (Budget: ₹1500 - ₹12500 INR, Jobs: Automation, Data Entry, Excel, Excel Macros, Power Automate, Python, Visual Basic, Visual Basic for Apps)