I have a worksheet that looks like this:

Worksheet 1
A B C
M/M Brown Brown Address 1000
M/M Adams Adams Address 6000
M/M Jones Jones Address 5000
M/M Smith Smith Address 10000
M/M Doe Doe Address 8000
M/M Hunt Hunt Address 15000

I need to copy the values in column A and column B to a new worksheet where
column C is greater than or equal to 5000 AND column c is less than 10000.
So the result woud be that worksheet2 looks like this:
A B
M/M Adams Adams Address
M/M Jones Jones Address
M/M Doe Doe Address

Ideally this would happen whenever I added a new row to worksheet1. Just to
add a wrinkle, I am using Excel 2008 for Mac and do not have any VB marco
capabilities. Help!