Combining multiple sheets to one master sheet, but need them to auto update

Hi,

I am trying to figure out how to merge multiple sheets into one master sheet and then have the master sheet auto-update if I make any adjustments to the other original sheets. I want the master sheet to then be sorted by date. I've merged sheets before , but since my current sheets have formulas in them to display a date, I am not getting the result I am looking for. I've also tried using the combine function under the data menu, but was unable to make that work. Any suggestions? I've attached an example of my document. It currently has 3 separate sheets, but I can sometimes have up to 10 separate sheets that will all need to link to one master sheet and then be sorted by date.

Thanks!

Something like this maybe? Pls see the file

Cheers
Azumi