In the cell where the formula should live:
- Type =average(
- Click on the first tab that should be included in the formula
- Click on cell B3
- Hold down shift and click on the last tab that should be included in the formula
- Let go of shift
- Press Enter
The formula will resemble:
=AVERAGE('Tax wk 1:Tax wk 52'!B3)
FYI, Your life will get easier if you will resist the urge to divide data up onto multiple sheets unnecessarily. This is called horizontal partitioning and it leads to trouble.