Good afternoon,

I have a problem that ive been trying to solve nearly the whole day but haven't been successful, hopefully someone here will be able to help.

I have a workbook with various worksheets January 2015 june 2015 December 2015 January 2016

In my first January 2015 in cell A2 there is a number
In June 2015 A2 has become a formula, making reference to a cell G2 in january 2015.
Now i want to copy June 2015 and the Rename it December 2015, but the cell A2 has to make reference to June 2015 A2 and not January.
The renaming of the worksheets ive done with VB. The ideia is to ock the worksheet and everything (just about) will be automatic, there are some variables in the formula that i will change when needed.

Regards