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- [login to view URL] 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. [login to view URL] duplicates [login to view URL] sherlock sheet, v-lookup those asin [login to view URL] #N/A [login to view URL] LPD set of ASIN Filter following column- LPD avail- Y LPD Prod Relevance- Y Invalid LPD- N [login to view URL] 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