look up data from a one w/sheet and take results to another w/shee

[AndyJ]

I have a list of data on one worksheet called raw_data coming from an
external HR database

example below:

Month Site Hire Date Name Employee ID
January Bedfont 01/01/2007 Andrew 000000001
January Bedfont 05/01/2007 Harry 000000002
January Hams Hall 31/01/2007 Simon 000000003
January Colworth 31/01/2007 Jenner 000000004
January Colworth 31/01/2007 Harry 000000005
February Leeds 09/02/2007 Simon 000000006
February Colworth 10/02/2007 Mavis 000000007
February Colworth 11/02/2007 Harry 000000008
February Hams Hall 12/02/2007 Jenner 000000009
March Colworth 13/03/2007 Harry 000000010
March Colworth 14/03/2007 Simon 000000011
March Leeds 15/03/2007 Mavis 000000012
March Colworth 16/03/2007 Harry 000000013
March Colworth 17/03/2007 Simon 000000014
March Leeds 18/03/2007 Susan 000000015

I would like to extract from the list and display on another worksheet
called Jan in cells a1 to e1 and below employees that match the month and the
site of Bedfont, I would then like to repeat the exercise a few cells along
for Hams Hall etc.

Then repeat the exercise for month of February.

From this I can then have a separate table which would count the number of
starters by location and month, and attach a hyperlink to it so that the HR
team can see a listing of how many starters in each month, and use this
information to prepare for inductions and other such HR related matters.

Any help much appreciated on how to achieve this.

Regards

Andrew