Rollover Workpaper

Hi -
I'm new to VBA and other advanced Excel tips.

I have a workpaper that has multiple years of rollover data. I have a tabs for every year 2007-2013 for over 30 entities (which means it has 226 sheets).
The next year references the ending balance in the prior year's worksheet. I have attached a sample of one entities' format with just 2012 and 2013.

I'd like to accomplish the following:

1)Create new worksheets for each entity by "rolling over: the 2013 worksheets and reference the 2013 ending balance number. Is there a VBA or similar I can do to automate this process?
2) I'd like to eliminate the 2007 -2012 worksheets without creating REF for my formulas (the beginning balance 2013 references ending balance 2012). Is this function possible?
3) I like to update a % change for each item on all worksheets (row 8). The cell references and are the same across all 30 entities.


Thanks for your help! Let me know if my question need clarification.

I appreciate any advice and could use any help I can get!!

1) Yes, but you will have to determine EXACTLY what needs to happen on each sheet so you can implement them in VBA.
2) You can click on the first one, hold the shift button, go to the last one you want to delete, then delete. it will delete them all together. If that is not helpful then I suppose you were unclear on your specific example.
3) I don't know what you are updating those WITH.