Formula or VBA to match a Sheet name to a particular cell and if it matches do a SUMIF on the worksheet than matches it.

[allygater]

[h=2]Formula or VBA to match a Sheet name to a particular cell and if it matches do a SUMIF on the worksheet than matches it.[/h]<ins class="adsbygoogle" data-ad-client="ca-pub-2974935598394359" data-ad-slot="8003857391" data-adsbygoogle-status="done" style="text-decoration: none; display: inline-block; width: 300px; height: 250px;"><ins id="aswift_0_expand" style="text-decoration: none; display: inline-table; border: none; height: 250px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 300px; background-color: transparent;"><ins id="aswift_0_anchor" style="text-decoration: none; display: block; border: none; height: 250px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 300px; background-color: transparent;">******** width="300" height="250" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" id="aswift_0" name="aswift_0" style="left: 0px; position: absolute; top: 0px;">*********></ins></ins></ins>

Hi

I am trying to create a formula to Match values in row 8 all of which are dates in this format - Jul-14,
I have worksheets that are named by these dates too eg Jul-14,

I want excel to see if there is a worksheet named what is in cell AA$8 and then if so,
perform a SUMIF on that worksheet to return a value (To update automatically to actuals). (if col A:A in the Jul-14 worksheet = the centre number e.g 58, then sum column AH:AH).

also....

if there is not a worksheet by this name I want the value to keep the formula it currently contains (The forecast calculations) so that if not actuals sheet is available the forecast info remains.


Hope you can help ​