OK here's the problem. I have, on sheet 1 of my workbook, lots of data with formulas spread among 143 rows and 40 columns. What this spreadsheet does is list values (broken down in their base form) for a mulititude of items, from many different sources (suppliers). I have set up conditional formatting on each item which compares each value from each source and determines the lowest and highlights that cell in green. What I would like to do is set up on each supplemental sheet is a table/list that references and shows only 1 of the sources and all of the green cells (lowest value) for that source only. This will eliminate all of the data which isn't the lowest (green) and will display just the items I want to see from each source (supplier). The data for these table will be updated weekly so I need to have the tables linked to the source data (not just cut and pasted) so when I update the source data, the tables/lists on each successive sheet gets updated as well.

Thanks in advance for anyone's help!