macro that lists a duplicate record of a staff in other pages on a new page

Hello all
I have a multi-page excel book. There are duplicate records on the pages. List staff records with a macro to the new page. Is it possible?
Thanks in advance for your information.
Win7 -Office2010

Attachment 24281Attachment 24282