Using VBA to search over multiple sheets and paste data into new one

[drabbit]

Hello,
Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion:
- multiple sheets (search in all of them)
- skip new reference sheet + few others sheets - for example sheet3 and sheet4
- in all sheets i've got names and number of hours next to them, I need to look for specific name within all sheets and once there copy whole row with it.
- if name is within sheet copy cell value B12 and C13 as well within same row in output sheet.

I've been searching for something like this within threads,and i found similarities but as I started this week i was not able to pull together exactly what I need from several scripts. Thank you for every answer.

 

[drabbit]

Thanks a lot, I put a bit of modification and its working like charm, is there also possibility to copy with the name from every source sheet, also cell B12 and C13?

 

[abhi221996]

hello there!
i am trying to copy every chart from multiple sheets and arranging them in a single sheet.
like searching every sheet for chart and then pasting it to a single new sheet.
but i am not getting the way of copying all the activecharts from every sheet and pasting and arranging all the charts to a single new sheet.