I'm a longtime Excel user but inexperienced at VBA, determined to become an expert this new year. My need is a macro that will search in the data in column E of "Master" worksheet for a specific name, then copy every row with that name in column E to a worksheet with that name. My Master list has data in columns A:G. Column E has the first names of my team members, e.g. Charisse, Nadia, etc. and each one has a worksheet with their name. I want to copy every row for each team member from the master list into their worksheet. As far as I can tell, this involves looping, copying data, and making sure each new row pasted goes to the next empty row in the destination worksheet. I appreciate any help I can get!