Excel Formula Required for VBA code for excel

[Panem Krupanandam]

I have created a excel invoice format, I wanted formula for this in vba coding...

previous sheet column c5+1, in active sheet.

For example: In sheet1 invoice no. 50, if I click new sheet in that invoice no. 51 should come.