delete duplicates items and keep duplicates others based on matching partial text and valu

Hi
I hope finding macro for bout 11000 rows between two sheets
should delete the items and add the others in sheet main based on matching sheet DATA with this cases
1- should match the partial text in column C (INVOICE,RECEIVABLE) and match the values whether in column D or E .
2- if there is the same partial text in column C (INVOICE,RECEIVABLE) and the same values in column D or E for two sheets , then shouldn't delete from sheet main with considering the repeated items should be the same in counting
this means if I have partial text in column C (INVOICE,RECEIVABLE) and the same values in column D or E for are repeated four times in sheet DATA but in sheet main are repeated three times then should add the fourth duplicates item into sheet MAIN to become four items as sheet DATA . as to if I have partial text in column C (INVOICE,RECEIVABLE) and the same values in column D or E for are repeated four times in sheet MAIN but in sheet DATA are repeated three times then should delete the the fourth item duplicated from sheet MAIN to become equal three duplicates items like sheet DATA .
3- if I have partial text in column C (INVOICE,RECEIVABLE) and the same values in column D or E in sheet DATA but not repeated item and not existed in sheet MAIN then should add it to sheet MAIN ,if I have partial text in column C (INVOICE,RECEIVABLE) and the same values in column D or E in sheet MAIN but not repeated item and not existed in sheet DATA then should delete it from sheet MAIN
4- any thing else except (INVOICE,RECEIVABLE) is existed in sheet MAIN then should deleted except row2 contains OPENING in column C.every time I will add new data in two sheets.
5- should highlight new items are existed in sheet but not is another as I did it .

the matching should be based on partial text and the same values together .
last thing I want the result in sheet OUTPUT with keeping the original data in two sheets ,should clear data in sheet output before bring data when run the macro . and sort it the first invoice and the second RECEIVABLE with make the duplicates values under each other of them .also posted here
https://www.mrexcel.com/board/thread.../#post-5938528

sorry for big explenation , but it's necessary

I hope somebody help

Hi bebo
first thanks for reply me .
second I know this is not easy . What I ask when search for some parts not whole the items . when you search between two sheets just based on part INVOICE and the same values in column D ,E let's take your example
INVOICE-MS22, 10000 serach part INVOICE also values in column D,E in sheets data,main
sheet data = INVOICE-A234 and the values in column D= 10000
sheet main =INVOICE-MS22 and the values in column D= 10000
as bold and should be search and match based on first part and same values in column D,E then the result in sheet ouput will be
INVOICE-MS22 and the values in column D= 10000 based on sheet DATA .
becuase different numbers invoices between sheets it take more time from me to how do that , that's why I want matching based on partial items and the same thing with RECIEVABLE . I know this is too complicated and confused . if you still interest and need more example just tell me .