Using If Large Statement and Populating Remainder of Table in Excel

I have a dataset that looks like the example below. I want to pull a list of the last ten transactions, ordered by Transaction Date, while capturing all columns of information in the original dataset; and I want to do this only IF the Salesman is Jimmy.

I'm stumped. Any ideas how to do this?

Example dataset below:

    Customer Name   Customer Group  Salesman    Transaction Date
    Sam                    1          Jimmy     3/21/2015
    Jill                   2          Johnny    3/21/2015
    Scott                  3          Joanny    3/21/2015
    Sean                   4          Slippy    3/24/2015
    Dave                   5          Slappy    3/25/2015
    Amber                  4          Slummy    3/26/2015
    Shawn                  3          Jimmy     3/24/2015
    Matt                   2          Johnny    3/26/2015
    Matthew                4          Joanny    3/24/2015
    Mark                   3          Slippy    3/21/2015
    Luke                   2          Slappy    3/26/2015
    John                   1          Slummy    3/26/2015
    Jonathan               5          Jimmy     3/24/2015
    Zach                   3          Johnny    3/26/2015
    Asher                  2          Joanny    3/21/2015

Desired output is of last 10 transactions ordered by Forecast Transaction Date

Customer Name   Customer Group  Salesman    Forecast Transaction Date