Absence tracker problem

Hi
I am trying to pick data from one table and dump it another and my head is going.
In the attached file you can see what I am trying to do (hopefully)
I have a holiday sheet but i need to be able to pull the data from the sheet by entering a week no in the recieving sheet(Tracker) and pulling only the data for that week and only for people who are absent.
As you can see in the attached file I have entered week 1 in the tracker and I need to pull what the tracker shows . You can see that bill is not in the tracker because he has not been absent during the week. I have seen something about using a Vlookup whith a "Match" inserted in the lookup formula this sort of looks the way to go but I am still having trouble in getting it to only select the data from the week no I enter in the tracker.
Any help would be great.
PB

Hi
First thanks Chemistb for your reply.

That works great for inputting the results in the table for the people in the tracker. But the employee names are not constants I need them to be imported into the recieving table only if they are absent for any day for the specified week.
If I enter week 1 bill has no entries (he is in work all week) so he should not be in the recieving table (TRACKER) same for week 2.
if I enter week 2, Bill, Tom & Cath have no entries so they should not be in the tracker.
However
If I enter week 3 bill has an "off" day on Wed so his name should then enter the tracker but Tom, Sam & Sue have no entries so they should not.

Hope this makes sense.
I only want employees in the tracker if they are off during the week specified.
I think I may have to do this in two steps ?