Dear Excel users

Is there a possibility to get average values of one column in multiple sheet and get the average values in new sheet.

Kindly advice.

I am having huge data containing multiple column in 10 different sheets.

Many Thanks
Balaji