Hi all. I'm new to this board and have found a lot of useful info. I've
tried copying some of the examples, but it's just not working for me.
I'm trying to do forecasts and I'm having a problem trying to figure
out how to link two worksheets and then have a formula in the same
cell.

Example: 2006!A21 =34567

After linking to the 2nd s/s, I need to have a formula to calculate a
10 week average which is the basic formula of =AVERAGE(A11:A20)

I've tried =(AVERAGE(A11:A20)&''2006!A21") but that only gave me the
average + plus the amount in 2006!A21. If I put SUM in front, then I
get a VALUE# error message.

The link would be to 2007!B21

The cell reference would also need to be adjusted to fill in weekly.

I hope this is clear enough.
TIA
Loretta