I would like to search worksheets that are listed in a table of contents and create a list of search results with unique values only. The attached workbook shows an example of the results for the search criteria Ref ID's that begin with "AB" or "CD". The table of contents page lists the worksheet name and the location of the data corresponding to each worksheet. For example List All searches column A and extracts data from column A, D, B, E, & C and paste the data into column A, C, D, E, & H of the results page. I created the sample results page by using copy/paste and then filtering the data. My original data is too long to keep performing this operation. Any help would be greatly appreciated.
Create_List.xlsx
Bookmarks