Max value across multiple sheets and corrosponding ajacent cells

[Xuseen]

Hello.

I have multiple sheets with results of diffrent loadcases. Every sheets has 4 columns. A - node , B - Moment (M), C - Normal (N), D - Shear (Q).

I want to make a summary of the results in one resultsheet where it shows Maximum Momement (M) and its corresponding Normal and shear.

IE. If maximum moment in node/row 1 is found in the loadcase in sheet 4 and max moment in node/row 2 is found sheet 6 - I want the values shown in the resultsheet to be M - N - Q from sheet 4 in row 1 and M - N - Q from sheet 6 in row 2.

Any ideas?

Thanks!