hey arlu

the sole reason why i was using workbook_event was to make the macro automated.

ideally i do not want the user to run any macros. i would like if.when they click on another worksheet, the data gets consolidated into the "master" sheet. does that make sense...will the updated macro you provided perform that task?

thx u so much for your help, it is really appreciated.