T-SQL Script to Write Quiry Results of Multiple Tables to Excel Workbook

We have a T-SQL script that shows query results of up to 50 tables. We want a script in T-SQL that will write the query results to an Excel Workbook with the query result of each table an a separate sheet with the table name on the sheet with the column headings on the first row.

Query Results

table1
IDNUM,c1,c2,c3, c3,c5,c6,c7 (Table Columns)
11111, 1, 2, 3, 4, 5, a, b
11111, 1, 2, 3, 4, 1, f, b
11111, 1, 2, 4, 4, 5, a, f
11112, 4, 5, 6, 7, 6, c, d
11112, 4, 5, 6, 7, 6, c, e

table2
IDNUM,c1,c2,c3, c3,c5 (Table Columns)
11111, 1, 2, 3, e, f
11111, 1, 1, 3, e, g
11112, 4, 5, 6, g, f
11112, 4, 5, 3, g, j

Excel
IDNUM,c1,c2,c3, c3,c5,c6,c7 (Table Columns)
11111, 1, 2, 3, 4, 5, a, b
11111, 1, 2, 3, 4, 1, f, b
11111, 1, 2, 4, 4, 5, a, f
11112, 4, 5, 6, 7, 6, c, d
11112, 4, 5, 6, 7, 6, c, e
table1|table2

Please reply with:
The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Will you require contact by voice and do you speak English? When you can complete the project.

Confidentiality.
a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above.
b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information.
c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons.
d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request