Multiple Data Extraction Filter with multiple criterias help required please.

Hi,

I am trying to created multiple tables in order to autofill multiple sheets.

From the Main CES table on sheet CES, I have managed to auto filter by platform (Form 7767 Drop down box Q5) and auto populating the CES Lookup Table. Using that table I auto populate Form 7767.

But my problem comes in when I need to further extract deficiency numbers from the extracted CES Lookup table to complete the Equipment deficiency Table and then again auto populate form B6530 sheet. I only require items which are missing on form 6530.

Any and all help would greatly be appreciated.