Hello guys, I hope someone may be able to help out. I need to get the average of multiple sheets. I will be adding sheets daily to add to the average. I have 6 Sheets now. The first sheet is named Summary and is where the formula will go. The sheets after are named by date so I have 08012020, 08022020 ,08032020, 08042020, 08052020. I only need to do 1 cell on each in the formula so I will need an average of A2 for every sheet. I will do the same formula for A3, A4 so on and ...... If someone can point me in the correct direction I would appreciate it. Thank you..