I know SUMIF doesn't work for 3D.

I have multiple worksheets say named 1 to 25

I wish to add column D if column A matches the correct
date(Reconciliation!$A10).

=SUMIF('sheet1:Sheet25'!$A$4:$A$500,Reconciliation !$A10,'Sheet1:Sheet25'!$D$4:$D$500)

I am not too clever and don't have too much time to teach myself the more
complex things excel can do. Is there is a simple way around this problem
other than listing all 25 sheets.

I have multiple uses of this type of formula if I could just find an answer
to SUMIFing 3D arrays.

When answering please assume you are talking to a novice!