Carry information from Sheet 1 to Sheet 2 maintain data integrity when adding rows

Attachment 444687

Question, Currently I am using the "=cell" in order to carry over information from one sheet to another. I have currently two sheets and an executive sheet.

Sheet Executive Summary
Cell C13 will always equal Unit 1 2016 A6
Cell C14 will always equal Unit 1 2016 B6
And so on.

However in Sheet 1 I have a macro that allows me to enter a new entry at the top. Well when I make the entry, it moves the previous entry down one and as a result the reference on the Executive Summary sheet also moves. How do I fix it so that when I enter a new entry on sheet unit 1 2016 cell A6 remains constant and the data that is being referenced on the Executive sheet will always look at the same cell?

I don't know if this will need to be done with a VBA or not. If it doesn't please advice and I will have this question moved.

I have looked at using the "$" in front of each item example: $A$1 but this doesn't work as the reference still changes on the Executive sheet when I add a new row.

Cell C13 will always equal Unit 1 2016 A6

=INDIRECT("'Unit 1 2016'!A6")

Will never change but also will not update when you copy the cell.