I just posted the same question and got the same good advice.

Now I'm wondering if there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.

"JE McGimpsey" wrote:

If the text is in Sheet1, cell A1, then in your summary sheet, enter

=Sheet1!A1

In article ,
mduck wrote:

Is there a function or formula that I can put in a cell to grab text
from a different sheet's cell? I'm working on a template for people to
use where they use different sheets in the same Excel file to provide
specific information. I want certain cells of info to automatically
populate cells in the Overall Template plan sheet. So that by the time
they are done completing all of the separate sheets, they will have one
master sheet that's already completed. Does this make sense? Any help
you have, I would greatly appreciate it! There has to be an easy way to
do this, but I'm not finding it.