=Hyperlink & Address Match formula

I want to have a hyperlink in B2, when I click on it, it should show me the units of that projectnumber in A2. All the units numbers with corresponding projects are in sheet DATA Units.
But I want it just to show the units that have an "N" in column M of DATA Units. (so it should show me 5 units, just like my formula shows), is that possible? Thanks! (I made a pivot too, maybe its needed, maybe not) I tried something like this: =HYPERLINK("#DATA Units!" & ADDRESS(MATCH(A2, DATA UNITS!A:$A, 0), 1), "Link"),
See attachment Projadmin16 - Copy.xlsm
Thanks!

Yes, it works but could u link your data validation with that sheet DATA Units (where it should show the unitnumbers with a 'N' (column M) only instead of the pivot? Thanks! fert.xlsm

Yeah I organized the pivot and doesn't seem to affect the data validation (just added a new criteria in the pivot, N or not.) and seems to go along. Ill try to have the pivot constantly updated somehow.. thanks for ur input. +Rep