What is the best way to have a worksheet protected from
viewing but still allow users to transfer information from
a second worksheet into the protected one?

We have mutliple users that would save information into a
worksheet, but the viewing of the information contained in
the worksheet has to be limited to a select few. How can
this be done?

Thanks