If you put the sheet names in column A, in this case just the numbers 1, 2, 3, etc... then this becomes simple enough.


A2 = 1 (the first sheet name, but it could also be Sheet1, or Monday, or whatever the real sheet name is)
B2: =INDIRECT("'" & $A2 $ "'!C103")
C2: =INDIRECT("'" & $A2 $ "'!D99") (this is just to show you create the first row of formulas to ref the cells desired)

When you've finished creating the INDIRECT() formulas in row 2 based off of the sheetname in A2, now copy that row of formulas downward and they will adjust themselves to ref the sheet listed in column A.