VBA Pulling Data From Other Sheets Remove Duplicates

Here's my best and final offer . I commented out the code that removes and attempts to add hyperlinks. I copied them over "as is."

It adds the space and wraps the hyperlinks. I "eyeballed" expanding column F to compromise between getting as much as I can on a line without wrapping and not getting so much on a line that it shrinks the text when printed. I set up printing for landscape, narrow margins and all columns on one page. The sample prints reasonably well in PDF.