Return to Answer

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select * Where Col1 is not null")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

There is a question in this site regarding the refresh of data taken from another spreadsheet:

How can I get Google Sheets to auto-update a reference to another sheet?

References

• IMPORTRANGE
• Using arrays in Google Sheets

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select * Where Col1 is not null")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

There is a question in this site regarding the refresh of data taken from another spreadsheet:

How can I get Google Sheets to auto-update a reference to another sheet?

References

• IMPORTRANGE
• Using arrays in Google Sheets

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 Where Not(Col1 ='')")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

There is a question in this site regarding the refresh of data taken from another spreadsheet:

How can I get Google Sheets to auto-update a reference to another sheet?

References

• IMPORTRANGE
• Using arrays in Google Sheets

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select * Where Col1 is not null")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

There is a question in this site regarding the refresh of data taken from another spreadsheet:

How can I get Google Sheets to auto-update a reference to another sheet?

References

• IMPORTRANGE
• Using arrays in Google Sheets

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 Where Not(Col1 ='')")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

References

• IMPORTRANGE
• Using arrays in Google Sheets

Yes, it's possible, but not in real-time, as it could possible if they were typing/viewing in the same document and screen area.

Use IMPORTRANGE() function to get the data from each spreadsheet and arrays to properly join.

I.E.

In the admin spreadsheet, in the A1 add the following formula to get the column titles from the Test spreadsheet 1.

=IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A1:H1")

In the admin spreadsheet, in the A2 cell add a formula like the following one to add the data from two spreadsheets

=QUERY(
{IMPORTRANGE("1piyeJWfr6oTkhwh-1mm8KiS4yB8uclDV2O_BG5przgg","Ark1!A2:H");
IMPORTRANGE(spreadsheet_key,"Ark1!A2:H")},
"Select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 Where Not(Col1 ='')")

Instead of spreasheet_key you should use the spreadsheet key of the second spreadsheet.

There is a question in this site regarding the refresh of data taken from another spreadsheet:

How can I get Google Sheets to auto-update a reference to another sheet?

References

• IMPORTRANGE
• Using arrays in Google Sheets