Find and Paste

[aftabn10]

I am looking to create a macro that will allow me to select everything that matches the following on the report and paste it into a simpler format on Sheet2.

SITE
TEAM
MEMBER
WORK DONE ONLINE
WORK DONE OFFLINE

Currently this report consists of alot of other data and has data for 500 members and I am looking for it to pick the above data for each member but also making sure it adds all members within their teams.

I have attached a sample highlight the required data on SHEET1 and SHEET2 shows how i would like the data to be pasted.

Hope that makes sense.

Thanks in advance.

[aftabn10]

Forgot to paste attachment.

[aftabn10]

I am guessing this has something to do with search strings. Any1 willing to help?