I'm looking for help creating a macro that will reference a list of unique values, pull 21 of those values to another sheet, and not duplicate those values when I request to pull another 21 values.

Example:

Sheet1 has 250 unique values in column A

Need to pull 21 of these values randomly into Sheet 2, Column A

Need to pull another 21 of these values the next day, clear the old values, but cannot duplicate the previous values on Sheet 2, column A

Right now I'm sort-of accomplishing this by utilizing the below formula:

=INDEX($A$2:$A$250,RANK.EQ(C2,$C$2:$C$250)+COUNTIF($C$2:C2,C2)-1)

With this formula, I've assigned random numbers in column C to the values in column A, and the values are placed into column D. However, this is causing an issue in that it changes every time I update anything on the sheet.

Any help would be greatly appreciated!