Help! How to use the result of a function as part of another

[dantonic]

I have a column with the top cell as the title. THis usually reads: "month total"

In this case for last month this title cell says: "May Total"

One of the cells in that column references values from the sheet named "May" This cell currently contains the following: "=May!C25&"/"&May!C24"

Every new month the title is changed. I would like the cell to automatically reference the new month's sheet... for example instead of having to go in and change the function like this: "=June!C25&"/"&June!C24"
I would like to add a function that will grab the first word in the title.

I was thinking along these lines: =LEFT(A1,SEARCH(" ",A1)-1)
but I am not sure how to incorporate this into the other function.. something resembling this, but that would actually work
"=LEFT(A1,SEARCH(" ",A1)-1)!C25&"/"&LEFT(A1,SEARCH(" ",A1)-1)!C24"

Hope the question is clear enough.
Thank you very much for any help

[rylo]

Hi

try

=INDIRECT(LEFT(A1,SEARCH(" ",A1)-1)&"!C25")&"/"&INDIRECT(LEFT(A1,SEARCH(" ",A1)-1)&"!C24")

rylo

[dantonic]

Hi

try

=INDIRECT(LEFT(A1,SEARCH(" ",A1)-1)&"!C25")&"/"&INDIRECT(LEFT(A1,SEARCH(" ",A1)-1)&"!C24")

rylo

Thank you very much!