Sheet to sheet Word String search for different cell copy

Folks I need help ASAP. I am trying to work on automating a report where sheet 1, looks at sheet 2 for data to copy over. Specifically, I need Cell X on sheet 1 to look at column B on sheet 2. If it can find a string of words "XXX" then it will copy Cell Y, from a different column on sheet 2 to cell X on sheet 1. If its not present, then I either want a 0 in cell x on sheet 1 or for it to be left blank.

PLEASE HELP ME. I have been banging my head, researching this issue for days to no avail. Thank you for any and all assistance.