Rewrite SQL Statement for Excel

My software that I use runs a Microsoft SQL Database server. There is 1 Server with multiple Databases. The software has the ability to generate Reports that are written in SQL that I run directly off the Software. I am looking to have the current reports that I am able to export from the program, run from Excel as I want them to update automatically and I also wish to be able to pull certain parts of them for different uses. I have 2 reports that I would like done, and the possibility of more if the Freelancer does a good job. Due to the nature of the Database being on a Local Server, I cannot provide direct access to it, But can provide the details of the current reports that I use. I am more than happy and have a basic understanding to test them on your behalf