Help getting Indirect Formula to update cells references when copied

Good morning everyone. I know the title may be a little misleading. As you would normally use indirect formulas so the cell references don't change. Which that is what I want in the end, but I need to copy them to an indefinite number of cells first and would like to not do it by hand. I have found some solutions to similar questions/problems but cannot figure out how to make them work for me. So, what I am looking to do is this... (I have also attached the spreadsheet for reference)

I have gotten the information in columns A through F on the first sheet to update as rows are added, moved, deleted on the second sheet using Indirect range. Also, I could do this for Column I (Copmleted Proj. Avg. Terminations) but I would have to do it manually (as I began doing in I3, I4 & I5) but that would be time consuming. So I am hoping there is a way I can copy the formula down the cells are updated for the initial copy but then don't update if the referenced cells are moved or deleted.

Hopefully between what the explanation and attached sheet it makes sense what I am looking to do. I also now realize there is probably a half dozen different ways I could have done this to make things a little simpler (I have learned a lot in the last few days) but if I can just get this to work for now, I can "clean" it up later.


Thanks in advance for any help provided and if there is any additional information or clarification needed just let me know.

Just realized I am having trouble opening the spreadsheet, I am not sure if other users are experiencing the same problem. If so, below is what I am looking to do in a nut shell.

I would like to have the formula located in I3 of my Estimates sheet update the cell references as I copy it from to I4, I5 and so on.

ex.
=IF(INDIRECT("'Project'!G3")=" "," ",(SUM(INDIRECT("'Project'!H3:ZZ3")))/INDIRECT("'Project'!G3"))
=IF(INDIRECT("'Project'!G4")=" "," ",(SUM(INDIRECT("'Project'!H4:ZZ4")))/INDIRECT("'Project'!G4"))

Regardless of how it is written the end result needs to be that if rows on Project are added, deleted or modified, it still looks at the numbers in the specified row.


Thanks again.