Merge multiple sheets data into one worksheet based on multiple criteria and date

Thanks Keeb for your details explanation. I know this is the texting (Demo data) which is not having proper date format buy when I change manually to dd-mm-yyyy date format.

I think this format will be easy for you to work on date format.

Copy of the data is attached.