Pivot Tables that pulls from different databases | Excel forum

Hello I've been trying to rebuild a spreadsheet that uses a Pivot table as the output sheet and so far it works for the individual databases but gives errors when I join the databases together.

The aim is to have an output sheet that shows units delivered and units in the system (open orders) and hopefully to bring in revised forecasted figures sometime later on.

Input data. I've copied and pasted the databases alongside each other so that it moves from left to Right with 2 reference lists of units. I then copy and paste the reference lists so that both of them are to the left of the data that is needed in the pivot table.

When I do the pivot table using the respective unit list and corresponding data it works but when I try using one list for both sources it come back with errors such as missing data. It seems like one list limits the other list. How do I get around this?

Lynda