Eliminate duplicates in worksheets

[maxebi]

I have two worksheets, 1st 'Rooster' and 2nd 'Paid' and I want to create a third worksheet 'Unpaid'. The first worksheet has a list of the complete rooster of names. The second worksheet has a list of who Paid. I need to compare the two worksheets and on the third worksheet list only the names who have not paid. I also need to pull the data from the rest of the columns from the first worksheet(Rooster) into the third (Unpaid).


Rooster worksheet
Name Address City Zip code Email
Mary 123 Elm St. Louis 65431 st.louis@yahoo.com
Jane 456 Pine New York 32145 newyork@gmail.com
Bill 879 Oak los angeles 98888 losangeles@hotmail.com
Sam 987 Redwood austin 65432 austin@msn.com
Joe 576 Dogwood salt lake city 55555 saltlakecity@yahoo.com
Sue 762 Main tempi 46263 tempi@gmail.com
John 987 Jasper dallas 87654 dallas@hotmail.com


Paid worksheet
Name Address City Zip code Email
Mary 123 Elm St. Louis 65431 st.louis@yahoo.com
Bill 879 Oak los angeles 98888 losangeles@hotmail.com
Joe 576 Dogwood salt lake city 55555 saltlakecity@yahoo.com
John 987 Jasper dallas 87654 dallas@hotmail.com



What I would need
Upaid worksheet
Name Address City Zip code Email
Jane 456 Pine New York 32145 newyork@gmail.com
Sam 987 Redwood austin 65432 austin@msn.com
Sue 762 Main tempi 46263 tempi@gmail.com


Thank you for your help

They came from two different excel spreadsheets and I'm trying to combine them and compare. This was done manual to see who has not paid.