@Vrushali_Gave The first Excel file that you had provided were not having the same template in all 3 sheets 
But this new file has the same template in all 3 sheets. Maybe I have got the output that you required. Can you just check the Output Excel below and verify if that’s the output that you require ?
Book1.xlsx (14.8 KB)
If it is not the required output, Can you provide us the Expected Output, then we can be more clear as to what we need to do.