Sum multiple Excel worksheet into one with PowerQuery

[s_1592]

Hi there,
Is there a way to sum a tab from multiple Excel files (a dozen or so), stored in the same folder, in a new file using PowerQuery? The tabs have the same structure across all files, and an example is as follows:

Tab "Staffing" of file 1

Tab "Staffing" of file 2

I'm interested in obtaining a new file (e.g., file ALL), whose tab "Staffing Plan" is the resulting sum of the above tabs (i.e., FTEs and Staff Costs for Jan-Jun 24 per department (RD, IT, HR).

Thanks in advance for your help!

 

[Matt Allington]

I have written many articles on the topic. You searched for Power query combine - Excelerator BI