Adding/Deleting Rows Across Sheets

[davin1130]

If i have 2 sheets. Sheet 1 holds all of the "raw" data, and i'm using sheet 2 to reference the data in sheet 1. How do i handle adding/deleting rows in sheet 1 so that sheet 2 is updated automatically. Example: sheet 1 has employee names and hours worked by month. Sheet 2 i'm referencing the names and using the hours worked to create an average. If i hire/fire an employee, when i add/delete the a row in sheet 1, how do i get sheet 2 to update without manually going in and making the changes in sheet 2.

 

[davin1130]

For example … in sheet 1 row 10 column A i have the name "Joe Smith" … in sheet 2 row 20 column A i have the formula ='sheet 1'A10 (value shows "Joe Smith"). If i delete row 10 from sheet 1 i get the error #REF for row 10 in sheet 2. If i add a row in sheet 1 (lets say above row 10), sheet 2 doesn't show the data at all.