Losing References

Your description is a bit hard to really understand but maybe one of these will do what you want. If you insert a row between Sheet1!A1 and Sheet1!A2 there will be a 0 or a blank cell between A and B dependant upon which formula you use. If you are to delete Sheet1!A1 Sheet2!A1 will be B.
This will show 0 where there isn't a value

Formula:

=INDEX(Sheet1!A:A,)

This will show a blank where there isn't a value.

Formula:

=IF(INDEX(Sheet1!A:A,)=0,"",INDEX(Sheet1!A:A,))

This workbook shows both formulae side by side for comparison