How to combine data from three separate worksheets into another worksheet?

[Mr. Snrub]

In Sheet1 I have "Date", "Description", and "Amount". In Sheet2 I also have "Date", "Description" and "Amount. In Sheet3 I have "Date", "Description" and "Amount". I want to create a Sheet4 that combines all the records in each of these tables so I can see ALL records in one table. And I want this new table to be added automatically when I add new records to any of the first three tables. How do I do this?

 

[awoohaw]

Use Power Query.
There are many Youtube channels that have great tutorials on Power Query.
These channels are my gotos: ExcelIsFun, Mr. Excel, MyOnlineTrainingHub, and Leila Gharani.

Here is a Power Query video about combining tables:

 

[Fluff]

Another option is to use

=LET(v,VSTACK(Sheet1:Sheet3!A2:C200),FILTER(v,INDEX(v,,1)<>""))