building a deck of drawable cards in excel

I am attempting to use excel (actually google sheets, if that's relevant) to assist in running a deck building themed game over the internet. I'm not particularly experienced and am having trouble figuring out how to do certain things. I've managed to get a check box working that, when pressed, generates 5 numbers without repeating, and then using those numbers I look up a description of the numbered card. I have 2 main issues.
One, is it possible to make it so cards cannot be draw again without "shuffling" the deck. I was thinking I could add a check box that automatically gets checked when the number gets generated to remove it from the list of options, but I don't know if that's even possible much less how to do it.
Two, I want to make it so the player can add or remove cards from their deck without having to go into the code and change things around. Inexperienced as I am anyone I'm going to add to this has no clue how any of this works.
also if anyone can tell me how to make it so a generated number adds to a list instead of just getting a new number that would be helpful, but I'm sure I can find out how to do that elsewhere, just haven't looked yet. Thank you for your time.