Hey, I want to split data in master data sheet based on some criterias, and then copy the data to different destination tabs accordingly,

criteria 1: = column email <>"", then copy paste them to sheet "email",

criteria 2: = column email ="" and column address <>*lost*, then copy paste them to sheet "address"

criteria 3: = column mobile <>"", then copy paste them to sheet "mobile"

can someone help me with the code to run above?

thanks!!!