How do you populate a google sheets excel column with cells from a column in another sheet in the same document

Question

In my Google Sheets document, sheets 1, 2, and 3 will all have columns x, y, and z in addition to the main sheet, which will include these columns. Sheets 1, 2, and 3 depict several individuals who are filling in the columns with data.

The main sheet's function is to display all the data that has been entered into the three other sheets' columns x, y, and zin so that it may be viewed all at once. Each person can track their own personal information on sheets 1, 2, and 3 without also viewing all the information from other people's sheets.

I want to be able to have sheets 1, 2, and 3 automatically pull new data and put it in the appropriate column on the main sheet in chronological sequence. I am aware that it is possible to make some cells show data from another sheet, but ideally, I would like the cells to automatically fill the next empty cell in the column they are in. On essence, the main sheet's columns and those in the other three sheets have the same names, and I want the main sheet's columns to fill up whenever new data is entered into the corresponding columns in sheets 1, 2, and 3. This should make sense,

For instance, if column x in sheet 2 was filled in with the name Jane Doe, the main sheet should automatically populate Jane Doe into the next available cell in column x. Then someone types in John Smith into column x on sheet 1 and it automatically populates the cell after Jane Doe with John Smith in the main sheet.

Here is a demo sheet with how I would like it to be, with the columns in the main sheet populated with the items in all the columns from sheets 1, 2, and 3: https://docs.google.com/spreadsheets/d/1y0dldFtq6NtLPjU21HVedtUzYKi-MjLTz62tupYbZGY/edit?usp=sharing

Is it possible to connect sheets within a document like this? Thank you so much in advance! :) Let me know if you need any more information.

Answer 1

You have two options on chronology:

sheet-by-sheet

=QUERY({Sheet1!X:Z; Sheet2!X:Z; Sheet3!X:Z}, 
 "where Col1 is not null 
     or Col2 is not null 
     or Col3 is not null", )

row-by-row

=QUERY(SORT({
 Sheet1!X:Z, ROW(Sheet1!X:Z); 
 Sheet2!X:Z, ROW(Sheet2!X:Z); 
 Sheet3!X:Z, ROW(Sheet3!X:Z)}, 4, 1), 
 "select Col1,Col2,Col3
  where Col1 is not null 
     or Col2 is not null 
     or Col3 is not null"; )