Extract Data from various worksheets

[adzi12]

Hello,
I have a huge work in excel. & wanted to extract particular data from each work sheet.
Let me clear:
I have man power data in my work book of various agencies. and agencies having man power in three categories i.e. Skilled, Semi Skilled & Unskilled
Agency_A:
Skilled = 05
Semi Skilled = 10
Unskilled = 15

Agency_B=
Skilled = 08
Semi Skilled = 20
Unskilled = 30

& so On..

Now i want to extract all that skill wise numbers in one summary sheet. how can i get it done through Macro/VBA or by any formula.

 

[arthurbr]

Try Copy/Paste/Merge examples
or
RDBMerge, Excel Merge Add-in for Excel for Windows