importing the last cell in the last row from one workbook into another workbook

[Pupabella]

hi, i need some help with the following
i have a workbook with sheets 1-40
on each of the sheets
i keep a running balance of what a tenant owes in rent being sheet name 111-1a in cell G24 balance is 0.00
than as i add another row of either credits or debits sheet 111-1a in cell G25 balance is 100.00
on the rest of the sheets in this workbook, the ending balance is always in collumn G but different rows
i need to take the end balance of each of this tenants and put it in a different workbook where i have my invoices.
and the arreares is in D84.
in my workbook i have all my invoices on one sheet, but different pages
in addition is it better to keep all different invoices in one worksheet, or assign each invoice to different worksheets?
any guidance would be appreciated, thank you.

[Dennis7849]

Can you attach a sample of the workbooks? You can change any sensitive info.

Is there any reason why the balance for sheets like "111-1a" cannot always be located in a FIXED position?

[Pupabella]

hi dennisware, thank you for trying to help me out
here are the two workbook
workbook one is one sheet with many invoices, each invoice has a page break, and prints on it's own
page. workbook 21 it has 40 sheets, one sheet per tennant

[Pupabella]

thank you in helping me out

[Pupabella]

Book1.xls
this is book one

[Pupabella]

Can someone please help me with this

I need to put the arrears due from book 21 sheet 111-d cell G14 into book 2 sheet 1 cell D2
i also need to put the balance due from book 21 sheet 111-1d cell G15 into book 2 sheet 1 cell D3.

in addition every month there is a new arrears and balance due added to the next row in book 21
and i have to enter the new updated information into book 2 in the Arrears due, and Balance Due
attached are the workbooks i am working on. Book 21 does have 40 sheets with the same kind of information, and i would like to do that for the other sheets as well that new information gets added to, and update it into book 2 with the new arrears and amount due.
thank you

Book21.xlsBook2.xls

[Pupabella]

WOW over 100 members viewed my post and have not received any feedback
I question why?

[Pupabella]

i am not getting any help here, therefore i am marking this solved and unresolved