I copied a range of cells from Worksheet2 and went to Worksheet1 where I used
Paste Special, then clicked on Paste Link. The cell formulas now show a cell
reference back to Worksheet2. If I edit data in Worksheet2, it correctly
updates on Worksheet1. So far, so good.

However, if I delete a row in Worksheet2, that change does not show up in
Worksheet1. I get a #REF! error. If I add a row in Worksheet2, the added
row does not show up in Worksheet1, but all the cell references change row
numbers to reflect the new row number after the row was added.

What I really want to accomplish is that Worksheet1 is a single worksheet
with all the data from Worksheet2, followed by all the data from Worsheet3,
Worksheet4, etc so that Worksheet1 is always updated with any changes made on
the separate worksheets.

Am I expecting too much, or is it possible to do what I want to do?