Change the SQL Statement: PowerPivot adding a new sheet to an already combined (set of sheets) to database.

[countryfan_nt]

hello friends, Hope all is well!

need your help please with PowerPivot.

I have 5 workbooks (each has data in one sheet per workbook) in one folder, I want to combine all the sheets
in 1 database of the powerpivot. and I did it! thanks to the below website:
http://www.contextures.com/PowerPivot-Identical-Excel-Files.html

Now I added a new workbook (1 sheet in it), I want to add that workbook to the other 5.
without recombining all over again. I just want to add 1 to the combined 5. is there a way?

Your kind help is really needed and appreciated always; thanks in advance!

 

[countryfan_nt]

May I add additional info.? I used SQL to add the data from different sheets/different columns. the challenge is adding the below line/sheet; without re-loading all the previous sheets:
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\7-Q317.xlsb`.[Sheet1$]

Your kind help is appreciated in advance.
==========================================================================

SELECT [Sheet1$].*   FROM [Sheet1$]

UNION ALL
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\2-Q216.xlsb`.[Sheet1$]

UNION ALL
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\3-Q316.xlsb`.[Sheet1$]

UNION ALL
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\4-Q416.xlsb`.[Sheet1$]

UNION ALL
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\5-Q117.xlsb`.[Sheet1$]

UNION ALL
SELECT * FROM `\\BETA\MI_F_C\New folder\NYC\6-Q217.xlsb`.[Sheet1$]