Let's assume your Corporate sheet is called "Corp" and the next sheet is
"CC1" (Cost Center 1). You can do an exact cell reference... Say you are
looking for revenue for CC1. On the Corp tab, in the cell where you want
CC1's revenue to appear type "=", then click on the CC1 tab and click on its
revenue number, then press enter. The formula will look like this =CC1!B5
B5 being the cell on the CC1 tab where the revenue number is. There are more
advanced ways of doing this too, like using VLOOKUP and SUMIF.

"Deanne" wrote:

I want to sent up a main excel worksheet at our corporate office, and then
have a worksheet set up for all our other offices to use with some of the
fields on the main worksheet(each office will have different numbers to put
in the fields), and then have each office info drop into the main worksheet
so we at corporate do not have to rekey or cut and paste that info. How do I
do this? What is this called? I thought it was linking but now Im not sure.
Please help.