Filter based on a range of Values

OK - So imagine I have a column with a number of street addresses:

1 Fred St
7 John St
3 Fred Avenue
12 John St
15 Alex st

In another sheet, I have a series of street names in which I am interested:

John
Fred

I want to filter the first sheet to display rows which contain either John or Fred. I've tried a filter based on a custom formula. This will find all the ones with John:

=REGEXMATCH(A:A, "John")

and this will work if John is in D1

=REGEXMATCH(B:B, $D$1)

First how do I get this latter one to work if D1 is in a different sheet? Can I prefix the sheet name somehow? Secondly, how do I get it to work based on a series of different values (like John and Fred) stored elsewhere.

=REGEXMATCH(B:B, $D$1:$D$2)

You can use TEXTJOIN to concatenate all the cells of a range, avoiding empty cells: for example, this formula would take all column D. Obviously you can narrow it if you want, but just to show you:

=REGEXMATCH(B:B, TEXTJOIN("|",1,$D$1:$D))

While REGEXMATCH() will work in simple manner, you may also try the following-

=LAMBDA(lm,FILTER(lm,
MAP(lm,LAMBDA(x,OR(INDEX(ISNUMBER(SEARCH(SPLIT(x," "),TEXTJOIN("|",1,H2:H)))))))))
(A2:INDEX(A2:A,COUNTA(A2:A)))