Understanding/Reverse Engineering Original File

Hello!

A novice excel user here..
I am looking to understand the original excel workbook that I have and how I could reverse engineer it for my automation needs?
To give a better understanding how it works. I would go and select field H101 and then press ''Go'' to launch the query. Then it asks for login information and password, a new workbook opens with the information from the query. Unfortunately I don't really understand how databases work and how it pulls this information:
123.PNG

This type of query and many different I need to use on daily basis which can be quite time consuming to do 1 by 1. Thus I wanted to know how I could make that with a press of a button it already pulls the ''selected'' queries and applies filters / formulas / vlookups etc. that I need for them?


Thanks!

Thank you for correcting!