Try this:

=B4+INDIRECT(A4&"!C7")

With Apr05 in A4.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bill" wrote in message
...
I've tried using INDIRECT, but cannot find the correct syntax to make the
formula work properly.

If possible, could you please be a little more specific?

Thanks

"Ardus Petus" wrote in message
...
use INDIRECT

HTH
--
AP

"Bill" a écrit dans le message de
...
Can anyone please help with this function?

I have a large spreadsheet file with numerous worksheets.
Each sheet represents one month of the year and is named Jan05, Feb05,
Mar05
etc.

In the "Summary" sheet I want to automatically reference a range in the
other sheets.

For example:

In the Summary sheet column A, I have the sheet names:
Jan05
Feb05
Mar05
etc.

In column B, (let's use B5 as an example) I want a formula that reads
something like:
=B4 + Apr05!C7

This seems simple enough, but how can I write a formula that
'automatically'
enters the sheet name (i.e. "Apr05") in the formula?
The row containing the data for Apr05 is only created when that month
comes
along, in order to keep the file size as small as possible at any time.