Reference cell from another workbook

[oowop]

Excel always finds a way to test my excelformulagenerating skills.

This is a value from a cell =[Book1.xlsx]Sheet1!A1 which works by it self great. But I would need to pull sequential number from a column A:A full of numbers from 1 - 5000.

So the cell would need to have formula of some sort which adds a number value from A1, A2, ... to "Book" string.

=["Book" A1]Sheet1!A1

obviously this doesn't work. So how to make it work avoiding VBA if possible?

Solution will bring you immortality!

 

[dave3009]

You could use INDIRECT

=INDIRECT("[Book"&B1&"]Sheet1!A1")

 

[oowop]

INDIRECT hm... that's a new one for me I will have to look into it a little deeper what it does.

Regard yourself immortal from now on!

P.S.
May gods give you all sons or thank you dave3009.