Suppose I have 10 columns of data in worksheet1. I need worksheet2 to display
columns A, B, and C from worksheet1. How do I do this if worksheet1 is not
static (i.e. rows are constantly deleted and added in worksheet1)? Is there
any way I can do this without maintaining/updating worksheet2?

I've tried to put "=Sheet1!A1" in cell A1 of worksheet2 but it doesn't work
when I insert a new row into worksheet1. It automatically changes the formula
to "=Sheet1!A2".

Thanks in advance.