VBA to merge cells with identical content

Then could I use other functions to refer back to the hyperlink? Maybe something to do with OFFSET and SEARCH functions? Like creating a column concatenating all of the criteria for that specific cell in the pivot table, then using the search function on another sheet and finally using offset to get a hyperlink next to the pivot table?

Maybe something like

if(isnumber(search(concatenate($B$2,A5),Sheet4!$F$2:$F$1582)),offset(isnumber(search(concatenate($B$2,A5),Sheet4!F2:F1582)),0,-1),0)

*column F on sheet 4 contains the concatenated text (B2 + A5)*

This doesn't work though