I would like to collect data to a worksheet from different worksheets and
from different workbooks.
So I have to give different numbers to different things, but these rows are
in different worksheets and numbers have to be persistant.

For example I give number 1 to AAA (that is in worksheet #1)
I give number 2 to ABC (that is in worksheet #2)
I give number 3 to ACD (that is in another file worksheet #1) and so on.

I would like to collect data to another worksheet where I can see what was
the last number that I gave to something.
For this example: I need a worksheet where I can see that:
1 €“ AAA
2 €“ ABC
3 €“ ACD
€¦
How can I do that?
Thanks for your help in advandce.