Excel/Sheets Automation Streamlining

I have several inter-linked workbooks and online data feeds that I touch every day just to move numbers around. My goal is to turn those repetitive copy-paste moments into a single click (or, better yet, a scheduled trigger)... (Budget: ₹12500 - ₹37500 INR, Jobs: Automation, Data Integration, Excel, Google Sheets, Scripting, Software Architecture, Visual Basic, Visual Basic for Apps)