Take string value from cell to reference a sheet name

[Spyman3101]

Hello, I am in need of some help.


I have a yearly budget spreadsheet, it has multiple sheets with it. Example:
Year view, Jan, Feb

I am trying to reference the monthly sheet's cells in the year sheet, using ='Jan'!A1 to reference

My problem is rather then write this out every time I want to reference the cell next to it

So it should read:
A1 = 'Jan'
B1 = '='A1'!C3

Meaning that the value in A1 is Jan and B1 will take the value of A1 and use it to reference the sheet, but because '' is used to reference a sheet name its read it as A1 instead of Jan

I tried using this formula =" ' " &" "&A1&" " & " ' "
But it just outputs A1 into quotes like so 'jan'

Is there any way to create a formula to do this problem?

Thanks

 

[RoryA]

You need INDIRECT:

=INDIRECT("'"&A1&"'!C3")