Adding data from multiple sheets for individual people

Occasional Visitor

Hi,

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

@Myrah 

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