On Jan 3, 11:26 pm, Ken Johnson wrote:
On Jan 3, 11:03 pm, Robert wrote:

Hi Ken,
Only the row changes.
Thanks
Rgds,
Robert

Assuming DIVIDENDS RECEIVABLE is a number then maybe...

=INDIRECT(A1&"!J" & MATCH(9.99E+307,J:J))

Ken Johnson

I have of course assumed that DIVIDENDS RECEIVED is the last entry in
column J on each of the 20 sheets.
I hope this is a correct assumption.

Ken Johnson