I am wanting to pull the next value in a sequence from a list, and potentially 4 lists depending on type and then remove that value from the list so it is no longer available. I have tried lists. I have tried setting up IF statements. All attempts have failed. The attached has a page with lists, and the main spreadsheet for tracking up to date information. Any ideas?