Extract information from Multiple sheets

[bbc1]

I have a workbook with 12 sheets inside of it, each of these sheets is a
series of names and age groups how can I extract the information on a
particular group from each sheet to one sheet.
ie
Sheet A Billy u12 john u14 sarah u16, these are the same across all sheets,
but iI need to extract u14 group from each sheet into one, over 200 entries
in each
sheet, so need macro or a formula.

 

[Bryan Hessey]

Hi,

If you only need to do this once, you could either set Data, Autofilte
on each sheet, and select the under 14 range to copy/paste,
or,
simply copy and paste all 12 sheets into one sheet, and sort over th
age column and bulk-delete all unwanted lines. With 3,000 lines this i
not too cumbersome a task.

If you need to perform this task often, then you have the option o
either recording a macro as you perform the above, or getting some VB
code to join either the full set of worksheets or the selected range.
The drawback to VBA code is that if next time you have different Shee
names or need a different group you will need to know how to amend it.

Does this help?

--