Solved! How do have a formula change as hte worksheet changes,

May 3, 2018
2
0
10
=round(average(Week1:Week4!E2:E24),2) is in worksheet 4 when I move it to worksheet 5 should be Week2:Week5
 
Solution
It is very hard to create "automatic" forlumales where sheet names are involved. So, create a new sheet, put it in front of the others. In that sheet, put links to a cell(s) in each sheet where raw data exists, then create averages using the data in this single sheet.
It is very hard to create "automatic" forlumales where sheet names are involved. So, create a new sheet, put it in front of the others. In that sheet, put links to a cell(s) in each sheet where raw data exists, then create averages using the data in this single sheet.
 
Solution