Coping one cell values into different excel sheets by different

Closed
Ncnayak Posts 1 Registration date Monday September 14, 2015 Status Member Last seen September 14, 2015 - Sep 14, 2015 at 11:34 PM
I have one cell vales. I want to store that value into different cell in different sheet. Suppose I have 10 in cell A1 from sheet 1 today which will store in A1 from sheet2 . then next if I change value in A1 from sheet1 then This value should store in A2 from sheet 2 and so on.Thanks.