There are 2 workbooks as below:
A.xlsx and B.xlsx
Thinking about making a formula in the cell $A$1 of A.xlsx to refer to cell $A$1 of the last sheet of B.xlsx, just like the following.
It can be done by giving the last sheet of B.xlsx a name called “lastsheet” but it is not flexible when a new sheet is regularly added.
Any solution apart from VBA?