Hello, I'm Wes, and I'll be assisting you today.
To get this kind of functionality you are asking for, there are various software that act as an interface to pull data into the Excel Spreadsheet.
Such software is SharePoint Server, but costs alot of money and servers to get it working. The best method to use is to follow the steps in this link:
You could save it as a task / job to run every day for you, but might require additional programming steps. Give it a try and let me know what you think.
YOU can also write a TSQL command like this to export from SQL to an existing Excel file:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\testing.xls;', 'SELECT * FROM [SheetName$]') select * from SQLServerTable