The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information.
To help explain, at the moment I can link an entire column of 'Engine numbers' with number n (approx 300) rows and the corresponding data with no problem. But how would I go about linking for future rows n+1?
Any help would be much appreciated if there is a feature which can perform this function.