I am looking for a formula that will allow me to copy data from one
spreadsheet into another based on values within my initial worksheet.

For example, if I have 5 colums of data listed below and their corresponding
data;

A B C D E F
3 4 3 5 3 3

I only want to display data that is equal to 3 on another worksheet, so this
would appear as;

A B C
3 3 3

I am trying to find a formula that will allow me to pull across only these
values and exclude the other colums as they do not equal 5.

Thanks,
Brandon