Eg my Primary worksheet contains 40000 rows

Company/Project No/Project Manager/Project Status
02            004502    Bill Symonds        A
02            004503    Bill Synmods        C
02            004504    Bill Synmods        C
02            004505    Bill Synmods        A
02            002362    Fred Smythe        A
02            002363    Fred Smythe        C
02            002364    Fred Smythe        A
03            004572    Tom Riley            A
03            004573    Tom Riley            A
03            004574    Tom Riley            A
05            000262    Peter Jacobs        A
05            000263    Peter Jacobs        A
05            000264    Peter Jacobs        A
05            000269    Peter Jacobs        A

This file contains 40000 records in the spreadsheet, I want to be able to
split the worksheet so;

Create a new workbook for each Project Manager containing
    1 Worksheet named "Active"
    1 Worksheet named "Historical"

Can someone tell me how to process the records in the worksheet to be able
to do this.

Regards,

How are you deciding which records are Active and which are Historical?