Hi everyone I could use some help here. what i need to do is pull data from multiple workbooks into one workbook.I have one main excel file with a list of 1000s of parts. Now the part number for each part is in column "A". each part has a separate excel file that is given the name of the part number in column "A". I need to get the data from a cell in that file for each part into the main excel file. Now I know i can do this by simply doing [workbookname]sheetname!cell but then i would have to type each part number for every formula. Is there a way to reference the part number in column A which is the same as the workbook name into the formula so i can just write the formula once and drag it down the column.