Hi, Im trying to make a master product part list database for the small company I work for but Im a little rusty with Excel functions and I dont want to use Access.

I want to have a folder for each part number with its own workbook each with:
Please Login or Register  to view this content.
So I have a matrix of 4x3, lets say the file for this workbook "Part 01.xlsx" is located at \\Company\engineering\Part 01\

I will have a 3rd workbook of a simple list of all part numbers.

I know you can link a matrix from another workbook so something like
Please Login or Register  to view this content.
Then just drag the cells over

But how can I get the "Part 01" from a list in an array and have it populate from multiple worksheets?