I'm not entirely clear what your asking?

Are you saying just to take column B from one sheet and move it to another sheet before you enter new data in column B?

In other words, you want to keep and running history of old data!