Hello Everyone;
I am trying to create a dynamic year to date (YTD) Tab which will dynamically sum monthly Tabs from January, February, March ........December.
For example, In October 2013 and if someone wants to see the YTD outlook from January to March, this dynamic YTD will sum from January to March and not January to October 2013.

So this consolidation should be able to sum only consecutive months if a give month is selected.
If say, May which is month 5 is selected. the year to date should only sum up to May tab.
If April which is month 4 is selected, the year to date tab should only sum up to April. and so on and so forth. Any suggestions or help?

I hope I have been clear with the description of my problem.
Thanks in advance for your suggestions.