Merging Tasks w/ Parts ordered for tasks

I have two sheets, one consisting of tasks created by our production department and another consisting of parts created by our parts department. I'm wanting to merge the two so that I have a "Master" list of all tasks and what parts are ordered for them. This way I can sort and/or filter to find out what parts I am waiting on and for what task they belong to. Please see attached sample data to show what raw sheets I have (Tasks, Parts) and what I want it to do. I've also added a tab called Using Now and thats what I've had to create manually. But with over 1000 parts and close to 600 tasks, it's very labor intensive, especially because each list changes daily.

Any help would be greatly appreciated.

Thanks,

Jay