Hi all, I have four Sheets with the names "Summary , ddd , uuu , yyy"
in a workbook. I have data in Sheet("Summary") like see below

rows A B C D......col
1 xx rec ddd 1234
2 xx arc ddd 4568
3 xx rec ddd 356
4 ss arc uuu 1234
5 ss rec uuu 4566
6 aa arc yyy 1234
7 aa rec yyy 8999

i want macro which should check value of cells of column C and if that
value match with any sheet name in workbook then macro should copy
data from column A to D of same row of column C cell value and paste
it into matching name sheet. For example according to above data Range
(A1:D3) should be copied to Sheet("ddd") as value in Range(C1:C3) is
"ddd" and it matches with the sheet name. And like this so on. Please
can any friend tell me any simple macro which can do this job.