I have a workbook consisting of many unique worksheets. Each worksheet has a
similar but not identical layout and format. Within each worksheet there are
certain cells that are unprotected that enable inputs by the user. I want to
add a "dash board" feature (worksheet) that will enable the user to make a
single input that will change the appropriate cells on each affected
worksheet. Within each of these worksheets, I want to retain the user's
ability to overtype the input that was created by the "dash board". My intent
is to reduce the quantity of redundant user changes but enable them to
continue to have the freedom to make unique adjustments to any of the
individual sheets.

Hope this is clear enough - thanks in advance for your help!