Merging two sets of data into one output

Hello

I have two lists of data which I am trying to combine as one output, this is basically a list of orders I have which I am looking to match up with relevant jobs.

I have attached an example spreadsheet showing what I am looking for, the list marked as Data 1 shows all the relevant PO's with the part numbers, quantities and dates.

The list marked as Data 2 shows all the jobs which are required with their relevant quantities.

The list marked as Output is what I am looking to achieve automatically, this shows the Data 1 & 2 merged together to show which PO & quantity goes to each jobs, the blanks show as excess stock from the previous PO.

Hopefully I've explained this correctly.

thanks in advance.