Adding data from multiple sheets for individual people

Occasional Visitor


Each month I receive an excel sheet with names and earned wages. The monthly list grows each month as additional individuals are being hired. I would like to combine the monthly wages earned per individual. Is there a way to add wages from different sheets by using an employers ID? 

1 Reply


That could be done by Power Query if your Excel version supports it.