Hi.

I have a workbook set up with a sheet called "Tracker", with columns
set up as:

center# firstname lastname centername city state zip
country
1 John Doe Research Inc Anycity NY
01234 United States
2 Bob Smith Insight Corp Anytown NJ
56791 United States

All information is set up as straight text.

Now I have a protected worksheet linked to it, that pulls the
information into a different format (I have several different sheets
like these):

center # Name Address
1 John Doe Research Inc
Anycity, NY 01234
United States
2 Bob Smith Insight Corp
Anytown, NJ 56791
United States


The formulas for these columns a

center # is:
=T(Tracker!A2)

Name is:
=T(Tracker!B2&" ")& T(Tracker!C2)

Address is:
=T(Tracker!D2)&CHAR(10)& T(Tracker!E2&" ")& T(Tracker!F2&" ")&
T(Tracker!G2)&CHAR(10)&T(Tracker!H2)

I've copied these formulas down the sheet for 1000 rows.

When I copy and paste information columns of information into the
Tracker and press F9, the linked sheet updates beautifully!

The problem I have is when it is necessary to update the tracker by
inserting a row. When a new row is inserted in the tracker, the linked
sheet simply ignores the new row and adjusts, such that where it was:

Tracker!A2
Tracker!A3
Tracker!A4

After insertion it is:

Tracker!A2
Tracker!A4
Tracker!A5

What I want after insertion is:

Tracker!A2
Tracker!A3
Tracker!A4
Tracker!A5

I've tried to mess around with absolute formulas instead of the
relative ones I'm using, but it did not help either.

I dont want the linked sheet formulas to shift. I want each row to
always point to the same row, even if the data shifts on the Tracker
sheet.

If you are still with me, thanks for reading this all the way through!