Is it possible to list a filename in a cell and have other formulated cells
recognize the name as the filename and then pull the data from the file with
the data in it?

IE, I list the name of the file in one cell, and then the following data
cells pull the needed data from that file name, from the pre selected cell
ranges.

If so how?