Automation of search and extract data from SAP (IM33)

[Costtx]

I would like to create an excel macro where I can click on a button, and it will perform the following functions:

1. Open SAP Easy Access
2. Open IM33 - Display Budget of Inv.Prog.Position
3. Search terms laid out within specific cells
4. Upon displaying results, copy information displayed
5. Paste into a specified workbook.

I asked the question previously, and was advised that if I use Power Query I can manipulate the data and export it to excel. Can anyone please explain, if this is a resourceful option and how can I perform this function?

Thanks.