I am currently using Excel 2002 SP3, and have created a worksheet with linked
information to a source sheet. If I protect this worksheet, allowing users
to modify only certain cells, the protected cells (which have linked
information) do not update from the source with any user changes.

How can I allow user's to make a change in one area, and their input will
update the linked - protected area? (Trying to prevent users from adding /
deleting rows or messing with the formulae).