Say I have an excel file with two sheets:

Sheet 1
    2    2    2
    4    4    4
Sheet 2
    0    0    0
    2    2    2

How would I take the average of each individual value from sheets 1 and 2 respecting their positions to produce a third sheet with averaged values like so?

Sheet 3
    1    1    1
    3    3    3

I am trying to follow

If the sheets are not next to each other then:

=AVERAGE(Sheet1!A1,Sheet2!A1)