allocate only unique data to multiple sheets from the main data sheet

In the attached file, the Macro shall allocate the data from cells B:G, based on the content in column "F" to worksheet "cell 1".
The reference common in "cell 1" is cell H1, S1, AD1 etc...
The unique number for each machine's shall be the column D, O, Z etc...(WO no in sheet "cell 1"
Now I need the macro to perform the allocation by ensuring that WO no: is not repeated/duplicated in the list based on machine number (eg: 66124-1P2401..) .
The respective duplicate data shall remain in the same sheet without allocation.

Neither your above request nor the contents of your file make any sense to me.

So maybe you can clarify, or perhaps others with greater perception than have I ...