I have a overall spreadsheet with finances in it, one of the cells in it borrows the pipeline from another spreadsheet which I do invoices on... I have keyed these two together no problem...

However when I say have a lot of invoices on the pipeline spreadsheet it knocks the cell from say a A39 to a A45 this then gives a zero value on the other sheet which I have to go back in and manually change each time, is there anyway you canmake this somekind of floating cell which won't change its cell number, or will update in other spreadsheet automatically?

Many Thanks