If cell = X Then copy row to Worksheet named X. If cell = Y Then copy row to worksheet named Y. If cell = X and Z Then copy row to worksheet named XZ

[natekerbobs]

I have a spreadsheet with multiple headers and i need a VBA code that can search the first worksheet, named "Merged" for various words. So if the word "Nathan" is found that row is copied to a worksheet named "Nathan" and if the word "Tom" is found that row is copied to a worksheet named "Tom" and if both "Tom" and "Peter" appear on the same row then the row is copied to a worksheet named "Tom and Peter" etc... im new to this and I've checked the forum and havent found any question like this. i would greatly appreciate a code... Thank You Guys