"from each of the folders"? What folders, where, what corresponding values?
Do you have a set of files in a set of folders and the files in those
folders have a lookup table and based on the two variables you mentioned you
want to return values from these (closed?) files.
How does city and job code tell you which folder to look at? You would need
to set up some sort of lookup table listing the path and file name of the
folder, file, sheet, and range that each set of city and job code indicate.
However, to use this in a lookup against closed files is a problem because
INDIRECT only works with open files.