Jaime,

If you mean, can you enter all your data into the overview, and have it
automatically entered onto the appropriate quarterly sheets, then no.

The best way to do this is to not use 5 sheets, but use a single sheet.
Insert an extra column, with the heading "Quarter". When you enter your
data, enter the appropriate quarter number into this column. Then, when you
want to see first quarter results, simply filter your data set using Data |
Filter... Autofilter, and select the "1" from the drop down at the top of
that column. Or use the data set to produce a pivot table, which can do all
sorts of wonderful things.

In general, you only want information to appear in one place in your
workbook - otherwise, changes and checking become problematic.

HTH,
Bernie
MS Excel MVP

"Jaime P" <Jaime wrote in message
...
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!