Filter column by text and copy to another sheet

I have list of words, in row 1:3

and list of strings with numbers in Column A4:B4
Przechwytywanie.JPG

I want that if
in column B there is text form row A, copy the those strings with numbers to Sheet2

in column B there is text form row B, copy the those strings with numbers to Sheet3

in column B there is text form row C, copy the those strings with numbers to Sheet4

I tried to use Filter that contains word, but it filter only by
B1 instead of B1:D1
B2 instead of B2:D2
B3 instead of B3:D3

Please Login or Register  to view this content.

Please Login or Register  to view this content.