Transfer last row total from closed files to another workbook

[JACK JOUSH]

Hello everyone
I'm having one of my mental block moments with this topic so any help is much appreciated.
I have a folder with many closed files ( about 25 files ) Within these workbooks two worksheets ( cash payment & deferred payment ) for them same tables
and formats and headers in addition to the workbook named " TOTALS " where I would like to put a code in it that enables me to achieve two main points.
first point is Transfer last row total for both two worksheets (cash payment & deferred payment) from closed files to the same two worksheets in the workbook named TOTALS.
The last point is Transpose the sum total in row no 27 from horizontal to vertical fom the two worksheets (cash payment & deferred payment)
to the two worksheets (Cash Payment Totals & deferred Payment Totals) in the workbook TOTALS through two ranges as follows:-
The first range from cell ("B27:AF27") To the Cash Payment Totals sheet starting from the two columns ("B3 & A3")
The second range from cell ("AG27:BT27") To the Cash Payment Totals sheet starting from the two columns ("H3 & G3")
same two ranges but To the deferred Payment Totals sheet .... cells highlighted in this workbooks is only for clarification.
you can find the details in the attached example. Check workbook TOTALS .... Thank you very much for all of you

[JACK JOUSH]

Is there any chance for helping me in this topic please?

[JACK JOUSH]

I thank everyone who is able to give me some of your time to help me, I appreciate it very much.

[JACK JOUSH]

I can provide additional clarification if needed... thanks for any help you may have.

[JACK JOUSH]

I hope the above makes sense and someone out there can help me.

[JACK JOUSH]

Hope to find help in this topic. Are there any questions?

[JACK JOUSH]

Is there any of you, who could help me?

[JACK JOUSH]

Is it difficult to achieve this?