Excel Experts,

I have a workbook with several sheets named 2008, 2009, 2010 etc
Each sheet contains names and addresses.

I have another sheet called RepeatVic

I would like for the repeats to give me names that are duplicated in the sheets named 2008 - 2012 so I can just enter new data in 2012 and have the first sheet (repeat) automatically update IF a duplicate name is entered.

I would also like for the sheet to give me the duplicate addresses as well along with the other information in that table. All of my information are in table format so I can use TABLE[@Date] etc.

The tables are structured as such:
CaseRpt Date Mth IncidentLocation Neighborhood VictimName VictimOf Sx Rc DOB Age AgGrp

So every worksheet from 2008 - 2012 has those table column titles. It would be nice to have that same information copied over to the RepeatVic sheet. Right now, I copy paste everything into that sheet and have the duplicate value under conditional formatting enabled and then I sort by repeats. But that means that every single incident in the past 5 years is in that single worksheet, and every time I enter a new name, I have to reenter it in the repeats worksheet as well. I need not only the repeat names but the repeat locations as well.

I am sure there is an easier way, and I ask you, excel experts, for your help!

Thanks in advance