vba code to sort data in two sheets and copy and paste sort data in output sheet

Hello everyone!

Im new to VBA, wondering whether what im trying is possible. Forgive me if this is elsewhere but I've searched for several hours with no luck.
What I'd like to do is this:I want to sort data in generic and Mandatory & Differentiating sheets and sorting is based on "Y" present in boath sheet and want sort data in output sheet with yellow colour.

Please find the attached sample file.

Regards,
upa