I could use some help writing a code. I want to look at A:2 sheet1, and find another sheet with the same text that's in A:1. Then copy specific cells from that Row 2 sheet into the found sheet. Then move down to A:3, and find the sheet matching that text and copy over data from Row 3 into it's sheet. Continue, until reaching the end of data in column A.

Could someone help? Thanks.