Performing an intelligent sort based on cell value

Hi, I'm looking to make a formula that will intelligently sort through selected cells in rows and put the lowest valued cell on a different sheet of the workbook, while also depositing the contents of the cell to the immediate right of it to the right of cell in the new sheet as well. The one last thing I'm hoping it can do is put the header of the column in either the cell to either side of the newly created cells in the new sheet, or convert it into a note. My hope is that this formula will automatically go through my pricing worksheet and sort what vendor had the lowest price, with their lead time next to it, all on a seperate, easier to reference sheet because the spreadsheet as it is now is a huge spralling affair. Any thoughts or ideas?

Thanks!
Mouse