Referencing sheet name & data into reference sheet

[jord1979]

I have an excel file with 32 sheets (reference sheet & sheets 1-31 for days of month). Using =today() and =day() in the reference sheet, I'm looking to pull the content from sheets 1-31 based on the value returned from the =day() cell. Is this possible?

 

[Scott Huish]

Book1
	A	B	C
1	7/31/2024
2	31		15
Sheet1

Cell Formulas
Range	Formula
A1	A1	=TODAY()
A2	A2	=DAY(A1)
C2	C2	=INDIRECT(A2&"!A1")

This is pulling from the sheet named 31, cell A1

 

[jord1979]

Book1
	A	B	C
1	7/31/2024
2	31		15
Sheet1

Cell Formulas
Range	Formula
A1	A1	=TODAY()
A2	A2	=DAY(A1)
C2	C2	=INDIRECT(A2&"!A1")

This is pulling from the sheet named 31, cell A1

Thank you. If looking to pull a range of data from the spreadsheet, I've inputted the formula as follows: =INDIRECT(A2,"!A1:!B79")
I've tried a few different edits of this, but it doesn't seem to be pulling the data over. Any suggestions

 

[Scott Huish]

You're missing the &

=INDIRECT(A2&"!A1:B79")