Hi ,
we have data of 500 sheets which contains the same format twise in the same
sheet, the column heading are Date, Place,Called Number, Code, Minutes which
appears twice in each sheet but both data are different.

Date Place CalledNumber Code Minutes Date Place CalledNumber Code
Minutes
0909 EL 654P EL RIO E 1:55 CC 0909 XL 604P EL RI
X 2:01 CC
0908 MM 624E LL OPI M :18 CC 0907 YY 601P ZL RI
Y :01 CC

like this data will be there twice in a single sheet. So what I want is
I need the data in a separate sheet from all 500 sheets after adding both
the "Minutes" colums.

Thanks in advance.