Hi,

i planned to have the data from one sheet copy to another sheet automatically, i wonder would it possible?
example:
i have a sheet, named it "Master", other few other sheet, named it as user1, user2 and so on
all sheets will have the same headers, when user A entering the data on sheet "user1" row 2, the data will automatically copies to "Master" sheet row 2. same go to User B, when he entering data on sheet "user2" row 2, the data will be copied to "Master" sheet row 3 (since there is data on row 2).

basically, "Master" sheet is to collect all the row data from multiple sheets and combine it.

can anyone please help?

thank you in advance.