Kindly help me solving searching problem in excel.

I have to copy and past following detail from one sheet to another.

For Example
i have list of 1200 sites with location and telephone numbers and other detail in next columns
A1 to A1200 Sites IDs
B2 to B1200 other info.......

i have to take out 100 sites + there detail along in separate sheet

+ many sites are repeated with different detail.
i want all detail against each site.

image is also inserted for support.
help.png