sort two columns, one from each of two sheets

[MrDB4Excel]

I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different sheet, is pasted into a separate sheet in one column thus allowing data sort on all in one column. Somehow I suspect tables and pivot tables is the answer. Any suggestions would be greatly appreciated.
The following diagram may help.

1st Sheet 2nd Sheet
Column A Column A

3rd Sheet
Column includes all entries from Sheet 1, Col A & Sheet 2, Col A

I should mention I actually need several columns to sort pas follows:
First sheet:
51 > 19FdO-1 Wed 02/Oct/2019 @ 20:10
54 > 19FdO-2 Thu 03/Oct/2019 @ 09:16
57 > 19FdO-3 Fri 04/Oct/2019 @ 06:44
Second sheet:
52 > 19TdO-1 Wed 02/Oct/2019 @ 16:01
53 > 19TdO-2 Wed 02/Oct/2019 @ 22:46
55 > 19TdO-3 Thu 03/Oct/2019 @ 11:34

In addition I actually have 6 sheets with a total of 98 entries (rows) across all six sheets that all need to be sorted.
In case you may ask; I need to do this to check the date & time in chronological order against the numbered column, in this case what you see here designated by 51, 54, 57, 52, 53, & 55.

 

[James006]

Just turn on your macro recorder ... and go once through your process ...

You will get a good starting point ...

Hope this will help

 

[MrDB4Excel]

Just turn on your macro recorder ... and go once through your process ...

You will get a good starting point ...

Hope this will help

Sorry, but this is above my pay grade. Process? What process?
I do not even know where to begin.