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.