I need to track down a bunch of MAC address based on the IEEE list. I have a list in separate sheets in an excel workbook. I also have a list of partial mac addresses in the last sheet from the IEEE that just includes the first 6 alphanumeric characters. I want to scan through all of the workbooks and, based on the search, create a separate sheet that just has the matching MAC Addresses. Hopefully this makes sense.
Far from a 'neat' answer (but more elegant probably means more difficult to explain) without much data to work from I'd suggest: