I am looking to have a master list with following columns:
index (#) | issues (text) | resolution (text) | severity (#) | status (open/closed)

This is all manually entered.

On another sheet I then want the top 3 of these (defined using a combination of 'highest severity' and 'open' displayed like this:

1 | Issue
| Resolution
2 | Issue
| Resolution
3 | Issue
| Resolution

I've tried using Match to get the reference but I would appreciate some pointers as I need to complete it today and had another load of work just pile on top!

Any help much appreciated