There are two tabs within one workbook. Sheet A has multiple formulas
reading data from Sheet B; Sheet B is an imported text file that can have a
range of results. I.E. Populated up to row 5 or row 60. I have created a
connection to that text file that allows me to "refresh" the results at any
time.

Once refreshed, the some of the formulas I created in Sheet A are then
altered. Why is this happening? My thoughts: when I "set up" the formula's,
my example data is only including data up to row 30, however, when I refresh
with real data, the data can alter to either be 60 rows or 5 rows, so the
formulas are jumping.

Is there any way to "hard code" the formulas so that no matter what changes
to the data, they will not change? Any assistance is greatly appreciated.

Example:
Sheet A formulas:
A2= Data!H3
A3= Data!H15
A4= Data!H27
A5= Data!H39

Once I "Refresh" the data in Sheet B, Sheet A's formulas say:
A2= Data!H3
A3= Data!H15
A4= Data!H27
A5= Data!H64