can someone advise how to calculate AVERAGE for certain reference, from multiple sheets, data is scattered in random row per each sheet.
Columns are same in all sheets, but rows differ in some as data is more vast.
For example: sheet1, reference which i need to calculate average for is in cell D2, but in cell J2 in sheet5, and in cell M2 in sheet 10 .. etc.
Thank You!