I have an idea how to do it but I am not able to write the macro. Please help with the below inputs.


Always the last filled row of all the sheets 1 to 4 has a line in which it is mentioned how many P1 or P2 are there with pass or fail.
So by taking that line as the validation, we can get the data to the required mail sheet to A10.

So, it should be like this i think

check if the last row of sheet 1 to 4 has any fail word then copy and paste from B4 of that sheet to the last filled row with autofit to the mail sheet starting from A10.
Then in loop again it has to check for fail in all the sheets and do the same thing again..

If we have to copy morethan 2 sheets of data to mail sheet (I mean on a day we have both P1 and P2 fail then we have to copy both the sheets in mail sheet)
So in that case we have to calculate the last filled row of sheet mail so that to copy the second failed sheets data in the same sheet by leaving 2 or 3 rows below the data in sheet mail.

If I am able to clearly explain the logic, please help me. Because I am not a software guy...

Thanks in advance...