Data is replaced in linked cell i need it to be preserved

[zach]

Hello, im kinda new to excel and programming and im a bit over my head at a work term for school and could really use some help. Im creating a new work order system for a company, im doing it in excel because i have basic knowledge of excel and none of access or other database software. I understand their may be better ways to do this but this is how im doing it for now.
My trouble lies in the fact that my initial sheet for an operator to enter their work order is linked to my master sheet. The operator (source) sheet is a series of drop downs and a description box. Each drop down box is linked to my mastersheet and it automatically updates onto the mastersheet when a drop down is selected. The killing point is that every time i change the data in the source sheet it replaces the data from before. I have experimented with macros looking for the last used cell and selecting that one but so far nothing has worked. Any help would be greatly appreciated.

[NoSparks]

My trouble lies in the fact that my initial sheet for an operator to enter their work order is linked to my master sheet.

Exactly, that's what the link does.
Don't have a linked cell assigned to the drop-down, do everything with your macro.