Do almost the same: highlight all sheets, then insert the formula in last
sheet, for instance in B1: =Sheet1!A1, hit enter, click on some other sheet
to undo shift action.
In all sheets, B1 cell will display the content of A1 cell from Sheet1. The
trick is, u have to start inserting on the different sheet when referencing
the given cell together with link to proper sheet while clicking on cell u
want to be referenced.

"Barbara" wrote:

Thank you, but what do I use for the formula?

"akphidelt" wrote:

Hilight all the sheets holding down the SHIFT key.
Then type in the formula where you want it... and then click on another
sheet to undo the shift action.

"Barbara" wrote:

I have a workbook with multiple worksheets. I want to enter a formula in
certain cells that will automatically put whatever text I put in a certain
box into all the worksheets. For instance, if I type in the Agency Name, I
want it to go into that cell in each worksheet. Can anyone tell me how to do
that?

Thanks