Need VBA AUTOMATION -- 2

Brief on Manual process which need in VBA automation-
Vlook up from one file to another and filter some criteria and take those data and then again vlook up in two sheets depends on its type, after that take looked up data from both two sheets and joined together. For last time it will vlook up again in that prepared joined sheet depending on the types.
Details-
1.Copy ASIN and CHECK column from allocation collated and paste it in a new sheet to check count and get the difference between NO count column and the allocated sheet.
2.Remove duplicates
3.In sherlock sheet, v-lookup those asin
4.Uncheck #N/A
5.For LPD set of ASIN Filter following column- LPD avail- Y
LPD Prod Relevance- Y
Invalid LPD- N
6.For BP set of ASIN- BP avail- Y
BP Prod Rel- Y
Invalid BP-N
Is PTD defect- Y
DP min check- Y
7.V-lookup those set of ASIN in 3p pasin inflow sheet SRC BP and SRC LPD to create ACE correction sheet
For correction value, vlookup H column from ACE patched volume sheet to the correction sheet.

can not upload the files here - please contact me for more clarification-8240378127