I've seen posts here and examples of spreadsheets that can automatically generate round robin schedules, but they're never able to generate RANDOM schedules. They're always predetermined based on a table

I would like to create a spreadsheet for him where he can input the names for a certain amount of teams (4, 6, 8, 10 or 12) on one page. Then, on another page, the schedule would be automatically generated. But I don't want it to be the same schedule every time.

For example: In an 8 team league, Team 1 would play every team once and Team 8 twice (assuming they played their schedule as follows: (1v8, 1v7, 1v6, 1v5, 1v4, 1v3, 1v2, 1v8). I can make that happen by myself, and it would be the same every season. However, I would like to see Team 1 maybe play Team 4 twice or Team 7 twice, not just always Team 8.

If anyone knows how to make it random (without a macro), I'd appreciate any help. Thanks!