I have a master workbook with a list of about 100 items and most of the items also have their own workbook with the name of the item as the name of the workbook. Within each workbook there is a worksheet that has data and I want so extract just a portion of the data into a single sheet in the master workbook. Is there a way to do this with VBA code where it loops through each workbook one at a time by finding the workbook based on the item name in the list and then extract data then close the workbook?