Joining content from different sheets

[gioCARRILLO]

I have several sheets with identical headers.

I would like to join them in a separate sheet and sort them.

On Google Sheets, it is very simple:

=SORT({Sheet1!A2:D100;Sheet2!A2:D100;Sheet3!A2:D100},3,1)

If possible, I would like to achieve this without macros.

Thank you in advance for your help.

[#2]

@gioCARRILLO 

Excel doesn't support UNION, at least directly. Thus I'd do that with Power Query - query one by one sheets, append and sort, return to new sheet.