Find certain number then copy it and 4 other cells to other worksheet

Hi, I am having trouble creating a formula. I am trying to search 2 separate worksheets for a certain number (ex. 34) and then copy that cell and the 4 other cells directly to the right of it. I want to them past them to a separate worksheet. Any thoughts on how I can do this? Thanks