I have a workbook with four sheets. The sheets have three columns: DATE CHEQUE ISSUED | CHEQUE NUMBER | CHEQUE AMOUNT
Here are examples to show what I mean.
SHEET1
2016/01/01 | 1 | $10
2016/01/22 | 4 | $20
SHEET2
2016/01/02 | 2 | $10
SHEET3
2016/01/22 | 3 | $10

What I would like is for data in sheets 1, 2 and 3, as soon as they are inputted, to be automatically copied to, and sorted in, sheet 4 so that sheet 4 would show:
SHEET4
2016/01/01 | 1 | $10
2016/01/02 | 2 | $10
2016/01/22 | 3 | $10
2016/01/22 | 4 | $20

As you can see the rows in sheet 4 are sorted first by date then by cheque number. Can this be done with formulas? macros? some other way?

Thanks for help with what is probably a simple problem for the experts on this list.

-- Arthur