First, you need to understand that Excel can't "dump" information from
one sheet to another. However, it *can* read information from one
location in another.

Therefore, if, for example, on your Fiscal Qtr sheet you have
information in cell C12 that you want to see in cell D20 of your Qtr 1
sheet, you would put this formula in cell D20 of Qtr 1:

='Fiscal Qtr'!C12

Follow this format for the remaining cells on your various sheets.
Then, as you enter or edit data on the master, the corresponding cells
on the designated sheet will automatically update.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=345944