Is there a way I can create an instructuion that dynamically includes a file
name? For example, I have a number of formulas in a worksheet that calls for
data contained in cells in spreadsheet xxx in another workbook. Depending
upon the workbook I am provided I want to be able to substitute xxx with yyy
and execute the newly modified formula using the new workbook and worksheet
as input rather than that what was originally defined.

What I am trying to do is build forms that I store in a folder. The data on
the forms would be extracted and processed. I don't know the name of the
files (or how many I will be receiving) this month. Anybody got any thoughts
about how I might do this?