If I have understood you correctly, you want someone to be able to
enter data onto one sheet and then have it stored in a relevant row on
another sheet.

This cannot be done with links.
You will need to write a macro to find the appropriate row and copy the
information.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup