Hi all,
i have a question that i will do my best to explain.

in a directory are visit reports (.csv format) that are completed on over 300 restaurants every quarter. Each file is called ### Unacceptable Q1/2/3/4.csv (Quarter number depends on the date it is filed.

What i want to to do is create a self populating workbook that have each EP store number on it (###) and automatically will indicate a certain cell reference (total score from related .csv file) in the new workbook when the .csv file is saved into the directory. I would open the new workbook once a week. It would allow me to see which visit reports have been completed and more importantly, which ones are still remaining.

i dont even have a clue where to start with this programming.

the file would be kept in the same directory as the .csv files are being saved into.

if anyone can help with this that would be awesome.

example of the workbook would be column A = ### (relative to how the .csv files are saved). then COlumn B would be Q1, C = Q2, D = Q3, E = Q4 - if Cell A2 was 019 - then i would want the programming for Cell B2 to look for file name "019 Unacceptable Q1.csv" and reference cell E2 in that file. and so on and so forth for approximately 300 store numbers and 4 potential reports per store.

thnask in advance!!!