I have a list of 10,000 unique people with corresponding statistics on a worksheet. These are also included on additional worksheets into smaller subcategories, so they are listed twice: once on the large list, once on one of the smaller lists. I want to be able to type that name on a third sheet (whether it's the first few letters, or entire cell exactly) in each cell within a block or designated area of cells ("named"?, i.e., A2:S100) that once manually entered into a cell within that block on the third sheet (realizing it has to be exact), that entry/name is removed from the other larger and small lists from aforementioned Sheets 1 & 2. (If can only be done with one other worksheet, i.e. larger list, that is fine).
Example: I manually type "Miller, John" in B3 of Worksheet 3, and upon "hitting enter", macro or formulas remove "Miller, John" from Worksheet 1 or 2, or hopefully both.
Delete name from Sheet1 as I type same name in cell of Sheet2