Here we have 2 excel file.

In first 2014 we have data and in second combine of all sheets.

There are different 14 sheets.

JR, SR, Std 1, Std 2, Std 3, Std 4, Std 5, Std 6, Std 7, Std 8, Std 9, Std 10, Std 11, Std 12.

Now in anther workbook where it is combined all sheet (all standard) you can see no data and formula is here only just refresh and data will combine and come here together.

Now you can see all standard are coming in.

Contact us for this type of report automation.

https://youtu.be/D9f3XAtoXSo