I would like the sheet name referenced in a formula to be relative to the
value in another cell. Examples:

If the value in cell A1 is 1 then my formula should be ='1'!B3

If the value in cell A1 is 2 then my formula should be ='2'!B3

Can this be done without programming? If so, how?