Offset not displaying result when there is Indirect

Hi there,

In a cell of Sheet1, i have this formula:

=OFFSET(Sheet2!$D$1,LARGE(IF(Sheet2!$F$3:F$1033>0,ROW(Sheet2!$D$3:D$1033)),$A12)-1,0,ROWS(Sheet2!$F$3:F$1033),4)


It works when Sheet2 data is not using the function Indirect (if data is manually entered, the above formula in sheet1 function and display the result. But if I use formula Indirect in the Sheet2, then formula in sheet1 will display nothing.

But in sheet2,
result in column D is date, ex: D1 =INDIRECT("'0" & A3 & "'!a1") (and the result is date, ex: 14/11/2021)
result in column F is text, ex: F1 = INDIRECT("'0" & A3 & "'!a2") (and example of result is: University)

Not working with these trials:
I have tried Ctrl+Shift+enter
I have tried n(Indirect(... or n(offset(...
I have tried Iterative Calculation on
I also tried copy value only of sheet2 to sheet 3, and Offset in sheet1 refer to sheet3 instead of sheet2
I have tried reset columns/cells format type to "general" or the "date" and "text" or "number" accordingly or "automatic"

Does it mean that offset can't take data from Indirect?
Or I have missed something?

thanks a lot
txt007