Cell content to replace sheet name in formula

[KranerRyan]

I would be a time saver if it is possible to use the content of a cell to link to a sheet.

For example:
I have a sheet named Jan, Feb, Mar, etc.. and a A1-A100 contains Jan, A101-A200 contains Feb, etc...
In B1, instead of =Jan!B1, is there a way to make something like =(A1)!B1 work so I can use the fill handle and change sheets without retyping for each month?

Thanks!

 

[alansidman]

Use the Indirect function

https://www.techonthenet.com/excel/formulas/indirect.php

 

[Marcílio_Lobão]

KranerRyan, Good morning.

Try to use: =INDIRECT( A1 & "!B1" )

I hope it helps.

 

[KranerRyan]

Thanks for the help!

Is there a workaround for the value in quotes to update with the fill handle as well?