how can i find average of values to a field present in 10 different sheets of
the same workbook. the fields may or may not be located in the same cell
position, so a lookup before average is necessary.

thanks in advance for all help.