Dear all,

please i need your help in solving the below problem:

I am preparing a report to summarize the Shortage amount for every employee
in each of the 3 items that we are selling to customers

Sheet 1: Item1 shortages as follow Staff ID Shortage amount

Sheet 2: Item2 shortages as follow Staff ID Shortage amount

Sheet 3: Item3 shortages as follow Staff ID Shortage amount

I need a function to consolidate in sheet4 the shortage for each one of the
staff in the 3 items

Sheet4:

Staff ID Item1 Item2 Item3
xxx xxx xxx xxxx


BR,

Khaled