See, I have 4 sheets (sheet1 to sheet4).

In all the sheets the last row is where the summary is stored. If that summary has the word "Fail" then it should copy from row 4 till the last row which is the summary row. same like that it has to check for all the sheets and do the same thing.

If there are multiple sheets which has Fail word in the summary row then it should copy both the sheets rows to a the final sheet which is named as Mail. If there is no "Fail" word in any of the sheets then it should do nothing.

Did I tried my best to explain my requirement?

Sorry for giving trouble....

I am not an expert...