I'm trying to link from 26 separate but identically formatted files to pull
in similar data. I want to use a single formula, but swap out the filename
based on the value I put into another cell. Anyone ever done that? I keep
trying but can't get past the formula error checker... I was working with 26
different formulas but need this flexibility to adjust to the amount of data
I need to collect from each file.