Please find attached mention 3 sheets with same heading
Section ID item count amt gross amt
Sheet 1 and sheet 2 need to add together for whatever matching section and ID column, Need to add together if section and ID repeating in same sheet or different sheet of sheet 1 and sheet 2 .
Sheet 3 is a negative figure as it item return, so what ever section and ID repeat in sheet 3 only add together .
Here I can only do by pivot in separate and vlookup for each column and its something like complicated.
Is there any better way for doing it?