Merging particular worksheet from Multiple Files in a folder into a single workbook

Hi,

Need your help on this.

I have around 11 circle files stored at the following path: C:\Bharti\MAPA\Circlewise\FY12-13\Circle wise MAPA_Apr'12

Each File contain performance KPI's of each circle. These performance KPI's are captured in seperate sheets in the file. i.e Finance KPI's are captured in the sheet named "Finance KPI's", Network KPI's are captured in a sheet named "Network KPI's", Revenue KPI's in "Revenue KPI's" sheet. and like this the file has around 11-12 different KPI's sheets for that particular circle.

What I am looking is to consolidate finance KPI's sheet of each circle (11 circles) into a single workbook. likewise, network kpi's sheet of each circle into a single workbook and so on for each 11-12 different KPI's sheet ..intent is to compare the all circles KPI's in a single workbook. Right now, I have to open 11 workbook of each circle and then do the copy paste and thereon analysis/comparison...

Look forward to your response on this at earliest.

Can someone reply on my request at earliest...

Need your help on this.

I have around 11 circle files stored at the following path: C:\Bharti\MAPA\Circlewise\FY12-13\Circle wise MAPA_Apr'12

Each File contain performance KPI's of each circle. These performance KPI's are captured in seperate sheets in the file. i.e Finance KPI's are captured in the sheet named "Finance KPI's", Network KPI's are captured in a sheet named "Network KPI's", Revenue KPI's in "Revenue KPI's" sheet. and like this the file has around 11-12 different KPI's sheets for that particular circle.

What I am looking is to consolidate finance KPI's sheet of each circle (11 circles) into a single workbook. likewise, network kpi's sheet of each circle into a single workbook and so on for each 11-12 different KPI's sheet ..intent is to compare the all circles KPI's in a single workbook. Right now, I have to open 11 workbook of each circle and then do the copy paste and thereon analysis/comparison...

Look forward to your response on this at earliest.[/QUOTE]