Thank's for helping me. I have modified the code as per my requirement to achieve something different. I will be having 4 sheets and it has to search the Fail word in all the sheets of last row and copy the data to the final sheet. It is copiying only from one sheet even though i gave the code to search in second sheet. My requirement is if it find the word Fail in another sheet also then it should give a row gap and then paste the second sheet data to the same Final sheet.
Here is the code which I am trying to use.
Bookmarks