Can I Call a cell value from a worksheets from file to another file

[azhr]

I have two files: File2019, File2020 and I want to call the value of cell (G10) from all worksheets in the "File2019" into the "File2020".

Can i do that with "Indirect" as done in this file to call the value "G10" from all worksheets?

Note: I don't like to use VBA

[Glenn Kennedy]

Will both files be OPEN? INDIRECT only works with OPEN files. How many sheets will there be in your real files?

[Glenn Kennedy]

Ignore my previous post.

=[File2019.xlsx]A!$G$10
=[File2019.xlsx]B!$G$10
=[File2019.xlsx]C!$G$10
etc

and update links when you open the 2020 book.

[azhr]

I hope not used VBA, and i hope used formula only, and the other file is not required to be open

i used about 50 worksheet in each files

[azhr]

thanx
but i want to same "indirect" formula, i mean can i used the cell value without sheetname as do you do

[Glenn Kennedy]

I did not understand this bit: "the other file is not required to be open"

Will 2019 be open or closed. Yes or No.

[azhr]

files closed

[Glenn Kennedy]

OK. With copy paste this can be quickly set up:

=CHOOSE(MATCH(B4,$B$4:$B$13,0),[File2019.xlsx]A!$G$10,[File2019.xlsx]B!$G$10,[File2019.xlsx]C!$G$10,[File2019.xlsx]D!$G$10,[File2019.xlsx]E!$G$10,[File2019.xlsx]F!$G$10,[File2019.xlsx]G!$G$10,[File2019.xlsx]H!$G$10,[File2019.xlsx]I!$G$10,[File2019.xlsx]J!$G$10)