Need a macro/formula to make summary sheet

[murugan1258]

Hi all,
I am new to excel so forgive if i ask any idiot question. I have a work book with 4 sheets in it. Now i want to make a summery sheet for this. Please find enclosed excel for more clarification.


Thanks in advance.

Regards,
MuruganCumulative Report.xlsx

[BS Singh]

Hi Murgan,


Please display your required output in summary sheet i.e. which all column you would like to collate from each sheet.

Regards,

[murugan1258]

Hi BS Singh,
I highlighted the area and mentioned what i need in summery sheet as per your instruction.

Thanks in advance
Murugan

Cumulative Report.xlsx