Copy cell value from one worksheet to another

[gailb14]

I know I have done this before, but I cannot get it to work. I want to copy values input in one worksheet to another worksheet. Simple but I can't get it to work.
THanks

[Moo the Dog]

There are a number of ways to do what you want.

Easiest:
If you want the value in cell E4 of Sheet2 to appear in cell A1 on Sheet1, then in cell A1 on Sheet1 enter:
=Sheet2!E4

If you need to lookup the value or compare other values to return the value you want, there's INDEX/MATCH, VLOOKUP, and other functions that can do this for you as well...

- Moo