filter to other pages automatically

HALLO everyone!

A friend is asking me to create a spreadsheet for maintenance in order to quickly identify working HCT's.

The filter tool is easy to use but they're not getting it at all.....

So instead of using that simple tool, I want to have the spreadsheet filter to other pages automatically.

Page 1 has all the details of every HCT.

The other pages pull information from that first sheet depending on certain criteria.

Can anyone help me with the formula for this please?

Vlookup is the sort of thing i'm going for but it needs to be indexed and the full row to be copied depending on a cell's value.

Thanks all:

maybe such feature as autofilter will be enought?

naaaah still not what I'm looking for.

Basically speaking:

Search column B for cells containing YES, copy the row containing YES here.

That's what I'm after. I'm sure there's a vlookup for it? :S Cheers again