Using data from worksheets with similar names

[lbrannon]

I have a workbook with multiple worksheets whose names start with "Observation" (Observation (1), Observation (2), etc). Each sheets layout is exactly the same, however there can be a variable number of these sheets at any given time.
In the workbook there is also a summary sheet with a cell where I need to take a single value from each "Observation" worksheet and average them. As far as I know I cannot use a formula since the number of "Observation" sheets changes, so I figured VBA would be the best way to achieve this if it's possible. But I'm very new to VBA so my knowledge is minimal. Any help is appreciated.

[JeteMc]

There is at least one way to do this by formula. Put a dummy sheet, perhaps called 'Start', in front of the first 'Observation' sheet and another, perhaps called 'End', behind the last Observation sheet. Lets say that you want to take an average of all of the values that are in cell B2 on all of your 'Observation' sheets. The formula would be =AVERAGE(Start:End!B2). AVERAGE ignores blanks so the blank B2 cells in the 'Start' and 'End' sheets won't matter.
Let us know if you have a questions.

[lbrannon]

One day I'll start thinking outside the box, I hope!

Worked Perfectly. Even with the Start and End sheets hidden.

Thank you!

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.