|within VBA editor of Excel, within "sheet change" you can trap which cells the drop downs are in for example, if the person name drop down is range "A1" and the month is in range "B1" you can trap them|
if Target.address = "A1" then
if "A1".value = "Name" then
Read the appropriate data from the other sheet and display on this sheet
if target.address = "B1" then
if "B1".value = "Month" then
Read appropriate data from other sheet and display in this sheet
The above is just an example of how to achieve this, it will not work you will obviously need to modify it, but i cannot help you much more unless i see the code you have. Give it a go and let us know what you find and we can try to help further.