Update cells based on cells in csv files

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!

i could be wrong, but csv files are comma separated values. As such you could open the file in notepad and read it. As such it does not have any cells, it is converted into cells when opened by excel. So you cannot get a cell value from it unless it is already open in excel.

If it is open the indirect function is what you should be looking at https://exceljet.net/excel-functions...irect-function