Connect Name Specific Row to another sheet

[hzafar1]

I want to connect one name specific row to another excel sheet. For example: I update a database with the incoming material consignments. if I receive material "A", I add a row of information in Master copy. Now, a tab specific to Material A is present in the same spread sheet. By adding information in material A, I want the excel to recognize A's description in master and automatically transfer the same information to tab A. And if I add material B, same thing happens in another tab. If I, down the line, make a another row of A, excel should recognize A, do the same. Can something be done to achieve this. In total I have a number of 27 materials. Thanks,