See SSIS Packages Run using Command Line at
http://www.excel-sql-server.com/sql-server-export-to-excel-using-ssis.htm[
^]
You may easily configure steps to repeat exporting.
But in any case you should prepare SSIS packages for every table.
You may use simpler way.
Just export your tables into CSV files, then open them in Excel and save them as an Excel workbooks using automation.