I am doing some spatial analysis on roads.
There are 15 roads to analyse.

The output is one excel workbook or one excel spreadsheet for each road.
I need to produce these workbooks or spreadsheets with formulas that should retrieve cell values from csv files.
The simplest setup might be :
15 Excel workbooks and 15 CSV files.
The workbook spreadsheet formatting has already been done.

My question is : Is it possible to configure a formula so that, according to the value in a cell, it would get the value from one CSV file rather than from another?
To be clearer:

Excel spreadsheet
One cell called "Roadname" contains a road name.
The other cells use this value to access cells either in roadname1.csv or in roadname2.csv?

Your answers will be much appreciated!