I am trying to create individual statements that pull only specified data
from a master sheet based on the data in one particular field (column B
below). Spreadsheet data is as follows:

Mastersheet: Sheet1
A,B,C,D,E
1:Joe;10;Cleveland;OH;196
2:Bill;12;Houston;TX;188
3:Harry;10;Chicago;IL;222
4:Joe;15;SanDiego;CA;311
5:Tom;12;Dallas;TX;124
6:Jim;15;NewYork;NY;297

Move data with the following end result:
Sheet2:
A,B,C,D,E
1:Blank
2:Blank
3: Joe;10;Cleveland;OH;196
4: Harry;10;Chicago;IL;222
5:
6:

Sheet3:
A,B,C,D,E
1:Blank
2:Blank
3: Bill;12;Houston;TX;188
4: Tom;12;Dallas;TX;124
5: Blank
6: Blank

Sheet4:

A,B,C,D,E
1:Blank
2:Blank
3: Joe;15;SanDiego;CA;311
4: Jim;15;NewYork;NY;297
5: Blank
6: Blank