moving data from one sheet to another automatically

[everardmajere]

Hi, i am trying to create a macro that will move data entered on three separate sheets to one master sheet either as the new line is entered or upon saving the document. The file has 3 different agents adding data to a shared document for internal audits, then a master audit sheet where the data is pulled from to get defect %'s. im looking for something that as each agent enters a new row of text that data is moved to the master audit sheet and put in the next empty line in the same order of columns as it was entered on their personal sheet. i dont know if this is possible to be done automatically or if it can be triggered on a save any help would be appreciated.