Hi,

Try this in cell B5 and copy down till B16

=indirect(A5&"!$B$35")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cav" wrote in message
...
I have 12 worksheets (Jan - Dec) each containing data for each month. I
also
have a summary sheet that i would like to link to the monthly data. On the
summary sheet my months are listed vertically A5 (Jan) - A16 (Dec) with
sales
data to go in B5-B16. Formula for B5 is =Jan!$B$35, B6 is =Feb!$B$35 and
so
on.

How can I set it up so i don't have to manually type in the worksheet
reference every time? For example it won't allow to reference the
worksheet
name from a cell: =A5!$B$35