Excel 2007 : Create list on new worksheet based on cell value

[ztaylor0]

I am new to the forum and tried to find what i was looking for prior to posting but could only find posts that were similar but not quite what I needed. So here goes.

I have a list of investors on my Master sheet, and I need to create a list based on the responses in Column B-E. I have attached an example sheet. I need the investor number to be included on a list on the appropriate sheet.

ex:
Investor HAM PRA UP HAFA
00064 no yes no input no
I need investor #00064 to go to 4 corresponding sheets, HAM NO, PRA YES, UP UNKNOWN, and HAFA NO.

I do not want the investor number to be removed from the Master sheet.