VBA Code to copy data from last filled column and paste to the next available column.

Good day everyone,

I am new to this forum so please forgive me if this problem is already solved. I am developing a financial analysis tool in Excel for my place of employment. My biggest issue is that I want to add subsequent years to the right. For instance, columns A, B, C might be years 2008, 2009, 2010. When we have 2011 numbers, I would like copy the formulas used in column C and paste them to Column D. When 2012 #'s are available, the macro would copy the formulas from column D and paste them to Column E. I have searched and searched for a solution but have yet to find one. Your help is greatly appreciated.

Take care,