ruchita

You said, "INDIRECT only works if you have all of the files you are accessing open"

This is false, that's why you include the whole file path C:\Windows\Program\etc....

You should probably read some online tutorials regarding the INDIRECT function because we've essentially given you the exact formula to use and all you have to do is replace for your particular file.