Excel 2010 :: How To Pick Last Entry In Range

I have to report Actual Headcount every month. Since I cannot add the Headcount numbers in the FY Column. What is the best possible forumula I can use to pick the last month's reported numbers into the FY Column.

For example.

I have 13 columns (A - M). Jan - Dec and the 13th column is the FY number.

This month, I am reporting March numbers in Column C

Column D through N (Apr through Dec) are emplty

I need Column N (FY number) to read Column C and enter the value from that cell.

similarly when I report April numbers in Column D next month, I want Column N to read April numbers and ignore the prior months.

I tried using the min/max function but since h/c fluctuate every month I could not use that. I could use an "if" statement and go back every column but that seems to be inefficient way to solving for this. Any thoughts?

BTW, I am using Excel 2010