how to shift a entire row down when offset is used?
 

I have a worksheet that contains data in one column(Column A) that is
populated into other worksheets. I use OFFSET to do this since we are always
adding new data to this column that I want shared with in the other
worksheet.The problem that I am running into is when I insert new data into
WS1 Column A, it is shifting down the cells that are only in the OFFSET. I
want to shift the entire row down in worksheet 2 since it contains other
cells that are specific to specific cells from the offset. How can I
associate these others cells with the offset column?




Example:
WS1


Row Column A Column B
1 Employee Date of Hire
2 Lisa 4-1-07
3 Lynn 4-2-07
4 Mark 4-2-07

WS2
Column A Column B Column A uses
=OFFSET(AWEsinprogress!$A$1,ROW(B1)-1,COLUMN(B1)-1)
1 Employee Salary
2 Lisa 10
3 Lynn 20
4 Mark 30

for example: If I insert a new employee (alphabetically) in WS1 I will end
up seeing the new entry (Liza) but the data from Column B does not move down
with the shift.

Row Column A Column B
1 Employee Date of Hire
2 Lisa 4-1-07
3 Liza 4-12-07 NEW
4 Lynn 4-2-07
5 Mark 4-2-07

WS2
Column A Column B Column A uses
=OFFSET(AWEsinprogress!$A$1,ROW(B1)-1,COLUMN(B1)-1)
1 Employee Salary
2 Lisa 10
3 Liza 20
4 Lynn 30
5 Mark
--
Priscilla