Excel Question: Dynamic File names possible? situation, different, possible, Windows, example

manchester88

I have a sheet where I have many cells linking to many different excel files. I was wondering if it would be possible to create a formula where the file name changes depending on a cell. So for example:

Cell A1 has the word "Finance" in it.

Cell B1 pulls from C:\Windows\Program\"A1".xlsx

So in this situation it would be C:\Windows\Program\Finance.xlsx

If I change A1 to "Economics" then cell B1 will pull from C:\Windows\Program\Economics.xlsx

I've tried using & sings and concatenate but they don't seem to work correctly. I get extra quotation marks or something. Does anyone have any ideas?