Excel 2007 : Recording One Value in Between Recaluclations

I am using the random number generator in excel. I have numbers that correspond to these random numbers, and I need the greatest of these corresponding numbers each time I recalculate with new random numbers. I can get the number I need into an isolated cell. However, I cannot find out how to export that number to another worksheet (or just another column on this worksheet) and start a list so that I can pull and keep that number from each recalculation. I know that I could copy and paste, however I need to do this thousands of times and I know there must be a more efficient way. It is probably a very easy command thta I just dont know exists. Any Ideas?