I have set up a workbook that has a master worksheet with sub worksheets. I
want to enter info on the master worksheet and have it automatically moved to
one or more of the sub worksheets.

This is being used for tracking line item work projects. The projects are
sent to one or more vendors and I want to keep track of what is at which
vendor by typing the info in the master and having it automatically update
that particular vendors worksheet.

Does anyone know how to do this? Thank you in advance for your help.