I need to figure out a way to reference a filter result.

For example, say sheet1 has some data, with column labels. I have filter selected, and you can select the item you want to see from each filter.

After the user selects the appropriate filters, he/she is left with one result. Unfortunately, excel still gives the result its original Row #. Say I have 2000 rows worth of data. The column labels take up just the top row, so after filtering, the appropriate result is shown directly below the first row; however, it is still labeled with its original row #.

How can I reference the result of an arbitrary filter in another sheet of the workbook? It would be preferable to not use a macro, since this document will be disseminated to many people, most of which are laymen.

I very much appreciate any help.

Thanks!