Filtering and displaying results

I need to filter a table consisting of 10 columns x 8 rows, for example. Depending on how the data is filtered, the final result could be at row 1 or row 8 or anywhere in between. This is where I am having the problem. Once the data is filtered, there is one row that is 8 columns wide with data in each of the 8 cells. What I want to do is take the final data from each cell in the row and and have it displayed in another cell elsewhere on the sheet. I have tried and tried and tried but I cannot get the data to transfer to the alternate location after it is sorted. I can do it prior to sorting but not after. It seems to be the changing row numbers that is the problem...or more likely it is me that is the problem. I can do with a pivot table but that is a little messy for what I need to do. Plz Help!!