How to show all entries that meet a certain criteria in a seperate worksheet

Hi,

I have been working with personal record data in multiple workbooks, using sumif, index, vlookup etc to show various required info.

What I now need to do is take all the records of people aged between 16-18 and list this in a new worksheet.

I can get all the records I need in a pivot table but it needs to be something I can add columns to in order to gather further info.

Any help would be much appreciated.