How to Summarize / Consolidate Data from Source Datas or One Pivot from multiple sheets

Hello,

Please allow me to ask a help from here again. I am truly appreciated that excel forum is a guide tool to me and grateful to those people are helping.

I would like to create *Summary amount automatically transfer from multiple transactions*.
I have tried myself the whole day by searching in youtube , and tried as in those video like *One pivot from multiple sheets and consolidate data , extract data* etc .
But, It doesn't work what I need. May be I don't know much how to do it.

Attached is sample file including my questions. Can someone guide me how to do it please ?

Thanks in advance for your time .

With best regards

in B8 to extract unique invoice numbers (ignore 0 at end of list)

=IFERROR(INDEX('Source Data Details'!$D$2:$D$1000,MATCH(0,INDEX(COUNTIF($B$7:B7,'Source Data Details'!$D$2:$D$1000),0,0),0)),"")

in A8

=IFERROR(INDEX('Source Data Details'!$F$2:$F$1000,MATCH($B8,'Source Data Details'!$D$2:$D$1000,0)),"")

in C8

=IFERROR(INDEX('Source Data Details'!$C$2:$C$1000,MATCH($B8,'Source Data Details'!$D$2:$D$1000,0)),"")

in D8

=SUMIFS('Source Data Details'!J:J,'Source Data Details'!F:F,"=" &$A11,'Source Data Details'!D:D,"=" &$B11)

in E8

=SUMIFS(Paid!C:C,Paid!H:H,"=" &$A11,Paid!I:I,"=" &$B11)

Copy all formulae down as far as required

Dear John,

It's exactly what I needed. Truly amazing and you save me .

And also thank you for your beautiful SUMIFS formula . I really learned a lot.

I can not thank you enough for your help and valued time.

Thanks again

Thank you for the feedback and rep.