Randomizing employee list with pairings without future duplicates

Hi there!

New to this forum and am excited to be a member. I have been on the search for an answer and am having a really hard time figuring it out. I am trying to work on a list that I will be randomizing each month to pair employees with someone new. I am having issues with the pairing part not showing up duplicates and also making sure the two people are paired together. (ie Alli is paired with Bobbie, but for some reason down the excel sheet Bobbie is paired with Steven). I felt like I needed to start all over as a new start and that wasn't working either. If I could get advice on how or what to do. I have seen some people do it with macros, but I don't even know where to begin with that. I have attached a mockup excel sheet with different information so I don't give employee information. However, the excel functions I have in it are still there.

Example excel sheet.xlsx