OK, But can I reference the row from the H column in the Takeoff Sheet? the cell H9 on the Takeoff sheet contains the "= Kitchenttes!L28", the row I want to reference is Kichenette!28. Is there a way to reference this row with a function from Takeoff Sheet? The rows on Takeoff sheet are copied and inserted depending on the size of the project.