Hi Guys ,
I have a workbook consist of 71 worksheet ,

In the first column of each worksheet i have a unique serial number that duplicate for all rows in the same sheet

In the second column of each worksheet i have a date which take from like 12/31/2017

Now i need to delete all rows from all worksheet that contain these dates in second column
"3/15/2017" "3/27/2017" "5/17/2017" "9/13/2017" "12/5/2017"


As i said before each worksheet has unique serial number in first column EXCEPT the last worksheet "sheet 71"

"sheet 71" contain a mix of all unique numbers that exist in all other worksheet , now i would like to distribute the content of "sheet 71" to other sheets depending on Unique Serial Number

So matched Unique Serial Number will be the key factor for distibutions and merging data , How can i do that in a quick way ?

Thanks