I think I might need a macro for this. WS1 is the master sheet. I
need something to find 18 different criteria in WS1colA, if it finds
it, copy only 2 of the rows data (col B and E) to WS2.
If it finds ZA01 in WS1col A, copy to WS2, if it finds ZA02 in WS1col
A, copy to WS3 etc.

If I add data to WS1, and the col A has the matching criteria, it
will
need to update the corresponding worksheets automatically.

Please advise.