GOOGLE SHEETS: Data from other sheets that grows as each sheet grows

[ShadowRider]

If I have a Google Sheet with 3 rows of data (lets just say 1 column of dataA,B,C), and a similar 2nd sheet with data (W,X,Y),
How can I get a 3rd sheet that contains the rows from these two sheets and also grows when sheet 1 adds D,E,F or and sheet 2 adds Z, AA, AB ...

Thanks,
-Eric

 

[Joe4]

Is this for Excel, Google Sheets, or something else?
I ask before you did not post this question in the "Excel Questions" forum, but rather the "General Discussion & Other Applications" forum, where people can post Google Sheets questions.
But you did not mention if this is for Google Sheets.

 

[ShadowRider]

Sorry - this is for Google Sheets.

 

[Joe4]

Sorry - this is for Google Sheets.

OK, please sure to always mention that in the threat title and/or initial question, as though there are many similarities between Excel and Google Sheets, there are also a number of differences.
I will update this question for you.