If the drop-down lists on the other sheets are getting the data from
your FORMAT sheet (through named ranges), then you only need to make
the changes to the FORMAT sheet. One way if you have made the same
mis-spelling several times is to highlight all the cells on the FORMAT
sheet (click the intersection between the row and column identifiers to
highlight all cells) then do a Find & Replace (CTRL-H) and type your
mis-spelt word in the Find What box and the correctly-spelt word in the
Replace With box then click Replace All.

Hope this helps.

Pete

Eloise wrote:
I've created a file with my lists on one worksheet (called FORMAT) and my
other worksheets pulling from that sheet to get drop-down options in each
cell. I've gone through an manually selected the cells to show the value for
each field, based on the drop-down list options. Now I want to make some
changes to the wording within the drop-downs (for instance, I saw a
mispelling).

Is there a way to make this automatically update in each of the sheets
pulling from the FORMAT sheet? Or do I now have to go through each sheet and
manually re-select the corrected word?