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#

Sales A.xlsx

Sales B.xlsx

Sales A+B.xlsx

alexnajm

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