Several ways but probably the simplest is copy each of the 12 cells in turn.
Go to your summary worksheet and paste - paste special - paste link.

If the value of the source data changes so will the linked cell.

"cheesy" wrote:

i want to link a cell from 12 seperate worksheet, ie the weekly total of sale
and have them appear as on final quartely figure on the last worksheet, how
do i link these together