Inserting rows in sheet from custom application and keeping internal links
 

I have the following problem:

I want to create an excel workbook with data coming from a database.
This done using VB.NET or any other programming language. The first
time the workbook is created there is no problem. Later on I want to
manually add sheets and use the data in the automatically generated
sheets. Still no problem so far...

I wonder wether it is possible to later on insert rows in the
autamically generated sheet, and not loose the links I made from the
manually generated sheets to the data in the automatically generated
sheets. This adding of new rows is also done by the program that makes
the workbook, so not from within excel.

For instance I have a sheet called input which is generated when the
workbook is first created. Cell A1 and A2 contain values that are used
in a manually created sheet (this sheet is created when using the
excel application). Now I want to insert a value between cell A1 and
A2, making A2 - A3 (with my own program). But I don't want to loose
the link/reference to this value, now in A3, in the manually generated
sheet. Is this possible or will the references always be lost because
I don't make use of the excel application to insert the new row?

Thanks, Sam Gerene