=Sheet1!$a$1
This entered in a cell on any other sheet will display the value in Sheet
1-Cell A1
If you change the value in Sheet1, the cell with this formula will change
accordingly.
Vaya con Dios,
Chuck, CABGx3

"Jaime P" wrote:

I have a worksheet with 5 tabs - 1 is a yearly overview, ie Jan - Dec. The
next 4 are quarterly tabs, therefore Jan - Mar, Apr - June etc. Can I put
data onto the first tab and have it appear in the correct cell on the
relevent quarter tab?
New to excel, would appreciate any help, thanks!