Macro to "find" a common value (it is in multiple worksheets but not on the same row), Then select the row that the value is in, then select the remaining rows in the worksheet, delete those rows, and then save the worksheet.
Solved by G. E. in 26 mins