Sort with autofilter(?) from one worksheet

[booiboa]

Hi guys,

Need help with this one.
Have a big list of product variations and I need to help customers to sort the data without getting lost. So my idea was to only show the head row where the autofilter boxes are in one worksheet, and the big databulb is in an other worksheet.
The result should be presented in the first worksheet though....

Is this at all possible? Any ideas?
Thanx,
Bosse

[booiboa]

To add more information to this one. Example of the file:

A1:|3|a|Product1|Titan|4-valve|Metall|0,1|Ingen VCU|Air-booster Yes/No|PH-kärl Yes/No
A2:|13|a|Product2|Titan|4-valve|Metall|0,1|VCU med tidrelä|Air-booster Yes/No|PH-kärl Yes/No

All and all +400 rows. Need to filter on column 4, 6, and 7 in another worksheet than the actual rows....
/Bosse