AUTOMATIC DATA UP-DATION IN ROWS

[debasis senda]

Sir

with regards, I seek your guidance in this regard as follows:

for e.g 

I want to input data's here i.e sheet-1,Row-2 and columns A to E (please refer to the attachment)

and this data will automatically get transferred sheet-2, ROW-5.

and again i will feed new data in Row-2 and columns A to E

and again it will automatically get updated in sheet-2,ROW-6 and 

similarly the same trend will follow i.e i will feed data in one row and selected columns

and that data will be updated in separate sheet in row-wise accordingly.

thanking you

Debasis Senda