I think that you will achieve what you want if you use the Vlookup function in your three subsidiary worksheets. Here is a link on how the vlookup works.
http://www.techonthenet.com/excel/formulas/vlookup.php

Alan