Excel 2007 : Budgeting question

[djv0001]

I would like to make it so that the Per Pay Period column (c2-c4) automatically adjusts to show the most recent pay period whenever I enter a new row into the payperiod table below(lines 8,9 etc…) Is that possible? Any other suggestions on how to make this budget more informative/useful/handy would be great.