Linking cells - when new rows are added to source sheet do I have to manually update links
We are reaching the referenced cell limit in our sheet so I have separate sheets to do the required formulas. To do this I have needed to link the "unique identifier" cells to the intermediate sheets so the formulas know what data to match (then use an index match back into the source sheet to populate the required cells).
My question is - we currently have 1500 rows approx in the source sheet and I have linked all those cells in 3 batches. Although we are adding to this sheet daily, and my question is, every day will I need to update the linked cells to now include the next X number of rows added?
I thought maybe I can add heaps of blank rows at the bottom of the source sheet - but as the entries are populated by a form and there is a auto column "created" I think this will affect where the new entries are populated.
Kind of defetes the purpose having to update the linked cells on a daily basis... may aswell just copy and paste the unique identifier column into the intermediate sheets...
Any help would be appreciated.