No, I'm afraid not -- INDIRECT is used to effectively cast the string to a range -- and to incorporate the variant filename you need a dynamic string in first instance.

As I mentioned, there are lots of alternatives you could consider - which is most appropriate for you will depend on many factors, e.g.:

- number of files you need to accommodate
- feasibility of using VBA
- feasibility of using 3rd party utilities etc...