Not sure of what formula to use or the best way to do this

Hi; I am trying to automatically give an average over several work sheets (tabs) but only if there is a value in the cell.  So if I have 10 sheets and I have a value in a specific cell on 4 sheets t...