excel/access question

Here's an example.

='Spreadsheet'!C853
is the name of the dynamic link, where 'Spreadsheet' (it must be in single quotes) is the name of the spreadsheet you're getting data from and C853 is the name of the cel you're linking to, e. g. it's in the C column, 853d row. The exclamation point is required for it to work.

If you add a row at, say, row 15, the link will update automatically and you will not have to change anything. It will just update itself one row downwards, and instead the link will be ='Spreadsheet'!C854

If, though, you add to row 854 instead (e. g. just below the row you're linking to), your link will not update automatically.

ok, but what i need is for every time someone enters a new job (adds a new row) to their personal page, that info will be sent to the summary ... which obviously should insert that new job into the summary and bump everything else down 1 row ... but in turn, that would cause a problem: lets say the heading IT is on pg 1 line 5, and below that are all IT jobs, then on pg 1 row 30 is the heading SALES, and below that all the sales jobs. well if someone enters a new IT job that would be inserted in the appropriate place on page 1, but the SALES heading would now shift to line 31, and that would affect all the cells from 31 on down ... also, if someone deletes a job,m that should delete it from pg 1 and shift all cells up, but again, that would mess up the formulas for the following job category ... so i guess my question is how do i make it possible for the pg 1 summary to know where job category one ends, and job 2 begins so there are no blank lines or overlaps in between? i hope im communicating this right, i really dont know. aside from having lines 5 - 29 on the summary link to lines 5-29 somewhere else and then starting job 2 at line 30, always line 30, i dont know how else to link it and make it adjustable...

I think you may need (ack, I can't remember what it's called) to anchor the cel. E. g. instead of C853, use $C$853