Lowest price & Lowest lead time

I'm new in this forum and need help to automate the work below:
I have an excel file with 3 sheets:
Sheet 1 has all data for Part #, Suppliers, prices, lead time.
I want to have a list in sheet 2 with all lowest price regardless lead time and a list in sheet 3 with all lowest lead time regardless prices from the data from sheet 1. Please see attached file.
Thank for your help.
Thup_98