Auto populating another worksheet problem

[Jimarillo]

I have a long list of data in worksheet 1 (columns A - Q) that depending on certain cell values need to be copied to another worksheet but can't seem to work out which way to go about it. Ideally would like it dynamic so updating worksheet 1 auto-populates other worksheets.

My data

Worksheet 1
Name, Address, Town, Car, Engine, Category, Licence, Day pass.

Worksheet 2 - Car 1000cc (1000 in Engine column)
Worksheet 3 Car 1600-2000cc (1600 in Engine column)
Worksheet 3 Licence holder (Y in Licence column)
Worksheet 4 Day pass (Y in Day pass column) etc etc

How do I do this, formula, lookup or maybe query?? I would also like to select which columns go into which worksheet e.g. Worksheet 4 does not need Licence column. Is this possible?

Now with attached sample data...

[AliGW]

Duplicate threads are not allowed. Continue here, please: https://www.excelforum.com/excel-gen...t-problem.html