Calc: How can I dynamically link all of sheets 2,3,4,... to sheet-1

[clear]

Is there a way to insert by reference/link all of sheet2 into sheet1, followed by all of sheet3… ? so that adding rows in the subordinate sheets show up in sheet1 ?

I am able to select a rows in sheet2, then Paste Special > Paste Special > links into sheet1. This allows changes in sheet2 appear in sheet 1. But if in sheet2 I add data in additional rows, it will not appear in sheet1 unless I copy-paste-special extra currently blank lines.

I plan on stacking all data from 9 sheets into a sheet1, each sheet appearing underneath the other (as opposed to side-by-side). While I can allow for future additions to the subordinate sheets by copy-paste-special a few extra rows (currently empty), it will not be practical for more than a few rows.

[schiavinatto]

Hi @clear, it might be more practical to have a single spreadsheet, with an extra column representing the Spreadsheet (2, 3, 4…), if you want the data from spreadsheet 2, you would use AutoFilter.
For a practical example, post an example file of yours.

[clear]

Thanks. I considered that. An hour ago I proceeded with the Paste Special > Paste Special > As Links approach I mentioned
above. On this combined sheet, I figure I can always run a Data > Calculate > Formula to Value to create a hard coded combined sheet.