Gsheet - How to merge 2 dfferents tabs in Gsheet with a common condition as "Yes"

[benzeming88]

https://docs.google.com/spreadsheets/d/1N35wUB-a7hDHFTzdhajlaCTJf_Ce34Ql3Miwq51JCqY/edit?usp=sharing Please take a look at the Gsheet.

1.) There are 2 different tabs with different fields.

2.) I need selected fields as shown in Combine Tab with a Common condition Damaged = Yes

3.) After that I have tried to sort with dates and the entire column is gone. not sure why. maybe is due to the formula I used.

This is a simpler version of my actual project. I cant share the actual one due to sensitive data. This is the formula I used for my actual project it works but when i sort by date... everything is gone. ={filter(NSU!A:A,NSU!M:M="Yes");filter(ACH!A:A,ACH!L:L="Yes")}

={filter(NSU!A:A,NSU!M:M="Yes");filter(ACH!A:A,ACH!L:L="Yes")}

It works but when sort by date everything is gone.