Power query and other methods

I manage monthly reporting for 100+ clients, and my Excel system already pulls in structured data from all major social platforms and our website through CSV exports. Everything drops into several tab sheets in my excel file. I have a summarized report for clients, a breakdown of the numbers, im currently copy and pasting the data because the format isnt the same as what i use to display the data neatly. That's where it takes time and I do this for all the platforms.

The only part that still requires manual log into AWeber, open each newsletter, and manually copy metrics (sends, opens, clicks, CTR, etc.) into Excel.

This breaks the automation flow and doesn't scale well.

What is the best method to automate or semi-automate AWeber → Excel so the data becomes query-ready and falls into place inside my existing reporting structure?