Extracting named cells from multiple sources

Hi,    I have a number of project management templates that contain info such as project number, start and end date, RAG status etc. All files are in .xls format, sit in the same network folder, and...