Any ideas...

I have a massive spreadsheet with lots of column headings.

I want to copy only certain columns of data based on given criteria from one columns. E.g. one column has request fields, so firstly I wan to filter on these fields to only show 3 out 10.

then based on everything that is now filtered I want to copy the data in column 1, 2, 3, 6 and 8

Does anyone know if this is possible?