Combining data from multiple worksheet from multiple files

[mlozovskaya]

I am trying to combine data from multiple files with multiple worksheet and the same schema: 

I have 2 files: Sales A and Sales B. Looking to combine worksheets  from each file to get results similar to my file Sales A+B with 2 tabs:

Source: Sales A Tab #W1#

Source: Sales B Tab #W1#

Expected Results: A+B Tab #W1#

 

 

 

[alexnajm]

Seems simple enough... read in both sheets, aggregate data, and output. Am I missing something?

[alexnajm]

This would work