A have the following sheet :

A1 | Day
A2 | 1
A3 |- (cel a1 from sheet Day (1) -
A4 |- (cel a2 from sheet Day (1) -
A5 |- (cel a3 from sheet Day (1) -
A6 |- (cel a4 from sheet Day (1) -
A7 |- (cel a5 from sheet Day (1) -
A8 |- (cel a6 from sheet Day (1) -


And I have 60 days, I want to make a formula that automaticaly reference the
correct sheet according the number above Day . The name of the sheet will be
something like Day (n), where n is the number in the cel A2.

Something like cel A3 :

='Day (value of cel A2)'!A1