,Hello Again

Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
on how many times I copy a sheet.

I hope this makes sense

Thanks in Advance
Allan