Linking Data based on criteria

[Wendy]

Hi

I would like to link data from my master workbook to 2 different workbooks
depending on criteria. If there is a value in either issued, paid or
receipted move name and column value to the workbook of the same name.
Can it be done?

Thanks

Wendy

Master workbook:-
Type Name Post Issue Overdue Receipted
Chq1 John Smith 10 10
PO Bill Jones 52 20
Cash Ted Green 80 80
chq2 John Smith 100 100


Issued, Overdue and Receipted Workbooks all contain these and also other
fields.

Name Total
John Smith 10
Ted Green 80